Re: vendor sql tuning

Could you also provide access and filter predicate information from the explain plan

amit

Chris Stephens wrote:

>in spite of the odd responses, i'm still working on this if anyone has
>any suggestions.
>
>i simply cannot get it to use the index without full scanning it.
>...when i take the order by part out and hint it to use the index it
>still full scans
>
>i broke the sql down:
>
>SQL> SELECT address.address_id
> 2 FROM clorox_prod.address
> 3 WHERE (address.company_id = 'SYS'
> 4 AND address.last_name = 'Plaugher');
>
>A
>

--
http://www.freelists.org/webpage/oracle-l