How do I view an execution plan in sql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

What are the types of SQL Statement?

3 Answers  


Does google use sql?

0 Answers  


Why do we use function in pl sql?

0 Answers  


Explain the components of sql?

0 Answers  


Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,






1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,


What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,


What is query execution plan in sql?

0 Answers  


What has stored procedures in sql?

0 Answers  


What is the purpose of primary key?

0 Answers  


Can I call a procedure inside a function?

0 Answers  


What is clustered index sql?

0 Answers  


Categories