REPOST: Re: Full table scan query

Although there are some bugs in the optimizer in 8.0.5, it should still obey a hint unless there is a good reason why the hint should be ignored.

Although I doubt you will have made such a trivial error, is it possible that your index hint was incorrect - e.g. using the table-name instead of the alias in the hint ?

The event that Sybrand was suggesting came out with a typo, I think, it should have been 10053.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Now running 3-day intensive seminars
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


Norman Dunbar wrote in message ...


>A developer is running the statement :

>

> select * from the_table where first_index_column = 'some_value';

>

>This will return 9 rows from the table.

>

>

>The explain plan gives a full table scan for the select above.

>When hinted to use the index, it refuses and again gives a FTS.


========= WAS CANCELLED BY =======:
From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk>
Control: cancel <1012067861.23600.1.nnrp-12.9e984b29_at_news.demon.co.uk>
Subject: cmsg cancel <1012067861.23600.1.nnrp-12.9e984b29_at_news.demon.co.uk>
Date: Mon, 28 Jan 2002 00:31:49 GMT
X-NNTP-Posting-Host: gyxrdvcf.demon.co.uk:16.145.243.174
X-Trace: news.demon.co.uk 278271228nnrp-38:1101 NO-IDENT gyxrdvcf.demon.co.uk:16.145.243.174
X-Complaints-To: abuse_at_demon.net
Message-ID: <cancel.1012067861.23600.1.nnrp-12.9e984b29_at_news.demon.co.uk>
X-No-Archive: yes
Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server
NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88
Lines: 1         
Path: news.uni-stuttgart.de!uniol!fu-berlin.de!arclight.uoregon.edu!logbridge.uoregon.edu!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller
Xref: news.uni-stuttgart.de control:40723152

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers.