PL/SQL - Indexed Select Statement

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 234 of 237

Indexed Select Statement

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

Total Answers and Comments: 3

Last Update: September 04, 2008 Asked by: bmsrao

Sponsored Links

Best Rated Answer

—

Submitted by: praveen_geek123

Use "Explain Plan" command

Above answer was rated as good by the following members:
varshal

August 27, 2008 03:13:27

Purshotam.d

Member Since: August 2008 Contribution: 1

RE: Indexed Select Statement

The way to check the statement is indexed or not via AUTO Trace -Â Trace only command

Is this answer useful? Yes | No

0 1

Overall Rating: -1

September 03, 2008 22:11:17

shaukat.vadsaria

Member Since: September 2008 Contribution: 1

RE: Indexed Select Statement

It is based on the time consumed to fetch the result set of the select statment. If the select statment is taking time to retrieve the data it mean that it is using the full table scan and no indexes or wrong indexes has been created in table

Is this answer useful? Yes | No

0 1

Overall Rating: -1

September 04, 2008 02:22:56

praveen_geek123

Member Since: September 2008 Contribution: 1

RE: Indexed Select Statement

Use "Explain Plan" command

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top