Answer Posted / b.v.srinivas
Explian plan describes the effective way to process sql
statement.
Explain plan is generated by Optimizer.
And explain plan is stored in library cache.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
what is foreign key? : Sql dba
what does the t-sql command ident_incr does? : Transact sql
Mention what are different methods to trace the pl/sql code?
Why indexing is needed?
What are analytic functions in sql?
what is the difference between nested subquery and correlated subquery?
What is secondary key?
How do you use collections in procedure to return the resultset?
Can we rollback delete command?
what is the difference between a having clause and a where clause? : Sql dba
What is data control language?
How can I see all tables in sql?
Is sql port 1433 encrypted?
What is the difference between sql and mysql?
what are the differences among rownum, rank and dense_rank? : Sql dba