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 we rollback truncate?

1083

What is the current version of sql?

1106

How do I remove duplicates in two columns?

1202

Is inner join faster than left join?

1287

what are all the common sql function? : Sql dba

1141

what is sql server agent? : Sql dba

1188

what is dbms? : Sql dba

1070

how to use regular expression in pattern match conditions? : Sql dba

1125

What is your daily office routine?

2351

how to start mysql server? : Sql dba

1279

what is schema? : Sql dba

1163

what are aggregate and scalar functions? : Sql dba

1142

Does group by remove duplicates?

1120

how to escape special characters in sql statements? : Sql dba

1124

what are the advantages of sql ? : Sql dba

1154