OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Force Index

Sun, 17 February 2002 16:37

Indra
Messages: 6
Registered: December 1999

Junior Member

Hi,

Can some one tell me what is the way to force a query to use an index.

Thanks in advance
Indra

Mon, 18 February 2002 01:32

pratap kumar tripathy
Messages: 660
Registered: January 2002

Senior Member

use hint /*+index(table_name,index_name) */

Previous Topic:	Dynamic SQL
Next Topic:	ORA-00604 & ORA-01000 Error , Help Please!

Goto Forum:

]

Current Time: Fri Apr 19 08:04:17 CDT 2024