SELECT * FROM ALL_INDEXES WHERE OWNER = 'MYUSERNAME' AND TABLE

how can we find the select statement is indexed or not?

Question Posted / tushar

Answer Posted / tushar

SELECT * FROM ALL_INDEXES
WHERE OWNER = 'MYUSERNAME' AND TABLE_NAME ='MYTABNAME' AND INDEX_NAME = 'MY_IND_NAME'

Is This Answer Correct ?

3 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is the purpose of primary key?

1029

Does varchar need length?

995

What is schema in sql?

950

What is the starting oracle error number?

1058

What is inner join in sql?

1082

Define tables and fields in a database

1131

How do I order by ascending in sql?

1024

What is rowid in sql?

988

What is sql basics?

1044

What are local and global variables and their differences?

1092

What is nvarchar max in sql?

1019

what is self-join? : Sql dba

1165

How do I run a program in pl sql?

1004

What is the primary key?

952

explain mysql aggregate functions. : Sql dba

992