| filter in explain plan [message #65311] |
Thu, 29 July 2004 20:17  |
Jay
Messages: 127
Registered: October 1999
|
Senior Member |
|
|
Dear All,
Can you please let me know whether the filter option in explain plan in good or not.
For a SQL query, I am getting the following output:
SELECT STATEMENT, GOAL = CHOOSE
FILTER 0
TABLE ACCESS BY INDEX ROWID JAY T_CURRENCY_EXCHANGE_RATE 1
INDEX RANGE SCAN JAY JKN_T_CURRENCY_EXCHANGE_RATE 2
TABLE ACCESS BY INDEX ROWID JAY T_PARTY_DETAIL 1
INDEX RANGE SCAN JAY JKN_T_PARTY_DETAIL 4
Hope you will please let me know.
Regards,
Jay.
|
|
|
|
| Re: filter in explain plan [message #65312 is a reply to message #65311] |
Fri, 30 July 2004 04:53  |
shoblock
Messages: 325
Registered: April 2004
|
Senior Member |
|
|
|
it's doing a filter because something in your query dictates that it must. Oracle doesn't randomly throw extra, unneeded steps into the plan. If you're getting the wanted results, then the filter is "good". If you're getting bad results, it's not the cause of the filter, but because you wrote your code wrong.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
