Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

index hint syntax

Status
Not open for further replies.
vadimg

vadimg

IS-IT--Management
Oct 25, 2001
152
US
hi.

what is the index hint syntax in Oracle?
I'm trying to:

select * from table (index = INDEX_NAME) where val = xxx

thanks
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

estersita
  • Locked
  • Question
How to convert SAS logic into a Oracle SQL syntax?
Replies
0
Views
252
estersita
estersita
lella2015
  • Locked
  • Question
Understanding Parallel hints on Tables and parallels in Create table as well.
Replies
0
Views
192
lella2015
lella2015
slicendice
  • Locked
  • Question
Best type of index to use...?
Replies
3
Views
279
taupirho
taupirho
pramsam1
  • Locked
  • Question
With Clause with UNIONS - how to enforce indexes
Replies
1
Views
458
LKBrwnDBA
LKBrwnDBA
cmmrfrds
  • Locked
  • Question
Use index to avoid full table scan
Replies
2
Views
275
sem
sem

Part and Inventory Search

Sponsor

Back
Top