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

Question Posted / bmsrao

3 Answers
17284 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / raji_4u

Check for "EXPLAIN PLAN".

Is This Answer Correct ?

16 Yes

2 No

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

Answer / bunty

To check the statement is indexed or not via AUTO Trace -Â
Trace only command

Cheers,
Bunty

Is This Answer Correct ?

8 Yes

1 No

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

Answer / 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

Post New Answer

More SQL PLSQL Interview Questions

How to sort the rows in sql.

0 Answers

Is truncate ddl or dml?

0 Answers

how to give permission to users that users can update/insert/delete on a row of table on timeing 10am to 6pm only?

4 Answers TCS,

What is cursor in pl sql with examples?

0 Answers

What is group function in sql?

0 Answers

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers

Are dml statements autocommit?

0 Answers

What is sql query optimization?

0 Answers

What are aggregate and scalar functions?

0 Answers

How many types of index are there?

0 Answers

For more SQL PLSQL Interview Questions Click Here