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 database white box testing and black box testing?

1105

What are the advantages of pl sql?

1119

What is a unique key and primary key and foreign key?

967

What is the advantage of index in sql?

962

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1176

Is left join faster than inner join?

1116

How is a process of pl/sql compiled?

1148

What is example of database?

1049

What is pl sql record in oracle?

1021

what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1037

Can we alter stored procedure?

981

Explain normalization and what are the advantages of it?

947

define sql delete statement ? : Sql dba

1009

Is not equal in sql?

1008

Which is faster union or join?

960