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 the purpose of primary key?
What is the sql case statement?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
What is trigger explain it?
Can sql function call stored procedure?
what is bcp? When is it used?
What is parallel hint?
what is commit? : Sql dba
what are local and global variables and their differences? : Sql dba
What is character functions?
In what condition is it good to disable a trigger?
What does seeding a database mean?
How do I start sql profiler?
What is a Mapplet?
What has stored procedures in sql?
