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

Local vs. global index

Status
Not open for further replies.
GT98SVO

GT98SVO

Programmer
Jan 10, 2001
25
US
How do I determine, throuth the catalog, whether an index is global or local?

If anyone can submit good links on performance tuning with indexes on partitioned and non-partitioned tables...

Thanks ahead!
 
Status
Not open for further replies.

Similar threads

slicendice
  • Locked
  • Question
Best type of index to use...?
Replies
3
Views
258
taupirho
taupirho
benamorton
  • Locked
  • Question
SQL Plus Number Formatting - to_number vs to_char
Replies
3
Views
447
SantaMufasa
SantaMufasa
pramsam1
  • Locked
  • Question
With Clause with UNIONS - how to enforce indexes
Replies
1
Views
406
LKBrwnDBA
LKBrwnDBA
cmmrfrds
  • Locked
  • Question
Use index to avoid full table scan
Replies
2
Views
228
sem
sem
Healthc12
  • Locked
  • Question
Issue with create global temporary table
Replies
3
Views
107
Healthc12
Healthc12

Part and Inventory Search

Sponsor

Back
Top