OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » explain plan

Tue, 12 February 2002 18:14

krishna
Messages: 141
Registered: October 1998

Senior Member

How do I make the explain plan to forcibly execute an index using a select statement?

Wed, 13 February 2002 07:37

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You use a hint to force the use of an index:

select /*+ index(t index_name) */ col1, col2
  from table_name t
 where ...

If you have just one index on the table, you can leave off the index_name:

select /*+ index(t) */ col1, col2
  from table_name t
 where ...

Previous Topic:	coping one schema to another schema
Next Topic:	SYSDATE of remote database

Goto Forum:

]

Current Time: Fri Apr 19 08:34:37 CDT 2024