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

Can pl sql procedure have a return statement?

959

What is out parameter used for eventhough return statement can also be used in pl/sql?

1014

What is AUTH_ID and AUTH_USER in pl/sql ?

2137

What is a sql*loader control file?

1159

What does sign mean sql?

1020

How can I speed up sql query?

905

What is denormalization in a database?

993

Why use stored procedures?

1018

Does truncate table reset auto increment?

939

What is difference between inner join and self join?

1028

How to take user input in pl sql?

1106

What are the commands used in sql?

1013

Can we insert in view in sql?

1002

Is sql a dbms?

938

What is the meaning of disabling a trigger?

1111