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

How to download oracle sql developer?

1124

What is write ahead logging in sql server?

1061

what is not null constraint? : Sql dba

1047

Why we use pl sql?

969

How can you fetch first 5 characters of the string?

1024

What is the best partition size for windows 10?

1014

How does join work in sql?

1022

what is 'mysqlshow'? : Sql dba

1040

what are enums used for in mysql? : Sql dba

1179

What does pragma mean?

1064

What is a sql*loader control file?

1277

write an sql query to find names of employee start with 'a'? : Sql dba

1040

What is the reports view in oracle sql developer?

1000

what is data manipulation language? : Sql dba

1027

What is sqlservr exe?

988