Have you tried using hints to tell Oracle to use the indices?
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Andy" <enzoweb_at_hotmail.com> wrote in message
news:8d4033cd.0201291457.65a7c4c6_at_posting.google.com...
> We have a loooooong running query, and after some investigation have
> determined that since it is using an outer join it is doing full table
> scans. According to some posts here, using UNION instead will cause
> the query to use the indexes:
><snip lots of query>
Received on Wed Jan 30 2002 - 02:57:57 CST
