Re: ideas for tuning a strange query?

From: Marc Billiet <someone.overthere_at_living>
Date: Fri, 01 Dec 2000 06:40:49 GMT
Message-ID: <20001201.6404982@slu40xxx.hae.hydro.com>

If you can't redesign the table, and you're using Oracle 8i, you can

maybe create a function-based index for RTRIM(B.ARTNO)||'*'||RTRIM(B.ARTICLENO)||'*'||RTRIM(B.DIMENSION) ||'*'||RTRIM(B.INTCOLOR). Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2000-11-30, 15:53:57, schreef tjmxyz_at_my-deja.com over het thema ideas

for tuning a strange query?:

> I have a strange query scenario.
> Maybe someone would care to comment.

> The query looks like

> SELECT
> A Bunch of field
> FROM
> SYSADM.SPECIFIC B
> , SYSADM.ARTICLE A
> WHERE
> RTRIM(B.ARTNO)||'*'||RTRIM(B.ARTICLENO)||'*'||RTRIM(B.DIMENSION)

> ||'*'||RTRIM(B.INTCOLOR) ARTIKEY(+);

> There is a unique index on ARTIKEY.

> any ideas for optimizing this query?

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Dec 01 2000 - 00:40:49 CST