OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » indexing

Thu, 11 April 2002 10:20

Julie Zolnowski
Messages: 9
Registered: April 2002

Junior Member

What is the syntax to specify the exact index you'd like to use in your select statement?

Thu, 11 April 2002 10:44

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

select /*+ index(t index_name) */
       *
  from table_name t

Previous Topic:	multiple tables update
Next Topic:	Displaying unrelated columns

Goto Forum:

]

Current Time: Sat Apr 20 03:31:45 CDT 2024