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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Runtime index

Status
Not open for further replies.
mverdera

mverdera

Programmer
Sep 30, 2004
14
CO
What is the syntax for making a run-time index? I have converted a field to numeric and am joining to another oracle database field which also does not have an index. I would like to build a run-time index on one or both. What is best? and how is it done?
 
Sort by date Sort by votes
The index is for a query run in crstal reports 9.0. I am converting a field in the query to match another oracle database table. I want to increase the runtime performance.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

slicendice
  • Locked
  • Question
Best type of index to use...?
Replies
3
Views
150
taupirho
taupirho
pramsam1
  • Locked
  • Question
With Clause with UNIONS - how to enforce indexes
Replies
1
Views
236
LKBrwnDBA
LKBrwnDBA
cmmrfrds
  • Locked
  • Question
Use index to avoid full table scan
Replies
2
Views
91
sem
sem
jaxtell
  • Locked
  • Question
setting a DEFINE value at runtime 2
Replies
1
Views
77
SantaMufasa
SantaMufasa
cmmrfrds
  • Locked
  • Question
Partition Wise prune table to index?
Replies
2
Views
86
cmmrfrds
cmmrfrds

Part and Inventory Search

Sponsor

Back
Top