Home » RDBMS Server » Performance Tuning » filter in explain plan
filter in explain plan [message #65311] Thu, 29 July 2004 20:17 Go to next message
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 Go to previous message
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.
Previous Topic: Table Corruption? Is there as such?
Next Topic: Understanding the Information Contained in the Parameter Box
Goto Forum:
  


Current Time: Fri Mar 29 00:39:39 CDT 2024