Re: Full Table Scan

From: "Steven R Fuller" <srfuller_at_doitnow.com> >> I have created the following sql select statement, unfortualty when I runit I get multiple full table scan's, How can I eliminate this with out altering my select statement.
SELECT DISTINCT /* INDEX (ptc) <<

Try correcting your hint to start with /*+ INDEX(etc.... Hints are comments and an invalid hint is ignored. No error is reported, but you can validate a hint (so to speak) by using an explain of the hinted sql. The plan will show the hinted access path being used when you have it correct assuming Oracle can do what you ask. You can hint an index that Oracle is unable to use do to the way the where clause is written.

Mark Powell -- Oracle 7 Certified DBA
- The only advice that counts is the advice that you follow so follow your own advice - Received on Tue Jan 27 1998 - 00:00:00 CST