Home » RDBMS Server » Performance Tuning » Different explain plan (Different explain plan)
Different explain plan [message #273275] Tue, 09 October 2007 16:20 Go to next message
Messages: 7
Registered: August 2007
Junior Member
Hi All,

I have a query that does not return any records right now. The query is as below:

SELECT /*+ rule */
h.tran_id, h.web_confirmation_no
FROM ordstat_hdr_buffer h
WHERE h.status_code = 'N'

When I check the explain plan, it shows that index is being used. However, when I remove the Rule hint and check the explain plan again, it shows full table access.
I understand that CBO is being used in the latter case, but why doesn't it use the index?

Re: Different explain plan [message #273276 is a reply to message #273275] Tue, 09 October 2007 16:23 Go to previous messageGo to next message
Messages: 25581
Registered: January 2009
Location: SoCal
Senior Member
please read & follow above guidelines.

Are statistics current on table & index?
Re: Different explain plan [message #273344 is a reply to message #273275] Wed, 10 October 2007 01:30 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because there is no index.

Previous Topic: Index creation....
Next Topic: Large table help
Goto Forum:

Current Time: Wed Aug 23 18:26:33 CDT 2017

Total time taken to generate the page: 0.04469 seconds