OraFAQ Forum: Performance Tuning » Different explain plan

Home » RDBMS Server » Performance Tuning » Different explain plan (Different explain plan)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Different explain plan [message #273275]

Tue, 09 October 2007 16:20

rubhatta
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?

Thanks.

Report message to a moderator