Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Slow running Query.
The difference between statement1 and statement 2 is that statement 2 requests
the data for one specific client_code and oracle can use an index
me_client_assets to quickly hone in on that particular client.
Statement 1 has no such limiting predicate and therefore Oracle can not use an index. If it can't use an index the only other option is a FTS.
Quoting "Kumar, Dharminder" <Dharminder.Kumar_at_Bmonb.com>:
--
regards
Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com
![]() |
![]() |