Continued Thread: Why would an index ignore a hint?

From: Craig & Co. <crb_at_amsa.gov.au>
Date: Mon, 14 Feb 2005 11:29:16 +1100
Message-ID: <420ff128$0$86898$c30e37c6@ken-reader.news.telstra.net>

Hi,

Thank you for your responses, so far.

I have since found out the query used would return no records. select /*+ INDEX (MESSAGE_DETAILS EXP_MSG_STATUS_IDX) */ count(1) from message_details where expected_message_status = 4; I then asked the developer to pick something that does exist and the result was the same
the query ignored the Hint (in the Explain Plan).

SELECT STATEMENT Optimizer Mode=CHOOSE 1 1497 SORT AGGREGATE 1 1
TABLE ACCESS FULL AUSDEV.MESSAGE_DETAILS 321 K 314 K 1497 The table has 386831 - expected_message_status code 3 records and 172 expected_message_status code 5 messages.

Cheers
Craig. Received on Sun Feb 13 2005 - 18:29:16 CST