Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

how to check index on oracle table

Posted on 2004-09-06
4
Medium Priority
?
9,540 Views
Last Modified: 2008-01-09
Dear All,

   kindly give me the query to check the index  for the oracle table........


Thanks,
Priyashree
0
Comment
Question by:priyashree
4 Comments
 
LVL 22

Accepted Solution

by:
Helena Marková earned 80 total points
ID: 11994396
select * from sys.user_indexes t where t.table_name='your_table';
0
 
LVL 143

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 80 total points
ID: 12004843
I would prefer DBA_INDEXES, as USER_INDEXES is only for the connected user's own indexes...
http://www.ss64.com/orad/DBA_INDEXES.html
also, which columns are actually indexes:
http://www.ss64.com/orad/DBA_IND_COLUMNS.html

CHeers
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What we learned in Webroot's webinar on multi-vector protection.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

886 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question