Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the commands youd issue to show the explain plan
for select

Answer Posted / saraswathi muthuraman

SQL> explain plan for select * from dual;

Explained.

SQL> select
substr (lpad(' ', level-1) || operation || ' (' || options
|| ')',1,30 ) "Operation",
object_name
"Object"
from
plan_table
start with id = 0
connect by prior id=parent_id;


SELECT STATEMENT ()
TABLE ACCESS (FULL)
DUAL

2 rows selected.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is integrity and what is constraint??Explain with example

2284


Explain what are the different type of segments?

965


How to use "startup" command to start default instance?

1035


Can we connect to ORACLE db using Windows Authentication?

1257


What are the ways tablespaces can be managed and how do they differ?

2368


How to handle a single quote in oracle sql?

1053


What is the parameter mode that can be passed to a procedure?

1047


what are bitmap indexes? How does they work?

2250


State and explain the different types of data models?

944


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1973


How to use subqueries with the exists operator in oracle?

1027


What is a proxy object?

1063


How to rename an index?

1073


Why does for update in oracle 8 cause an ora-01002 error?

1003


What privilege is needed for a user to create tables in oracle?

953