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
-- //www.freelists.org/webpage/oracle-l