Improve company productivity with a Business Account.Sign Up

x
?
Solved

how to check index on oracle table

Posted on 2004-09-06
4
Medium Priority
?
9,547 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
2 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

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
If you try to migrate from Elastix to Issabel, you will face a lot of issues. These problems are inevitable but fortunately, you can fix them. In the guide below, I will explain how I performed the migration while keeping all data and successfully t…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Watch the video of Kernel Migrator for SharePoint, which demonstrate the process easily of migration from SharePoint to SharePoint, OneDrive for Business & Google Drive servers, Public Folder to SharePoint, File Server to SharePoint. The tool has va…

584 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