Answer Posted / sureshkumar.somayajula
Explain Plan determines the execution plan for SQL
Statements.
Syntax:
expalin paln
set statement_id= ' Text '
schemaname.Table_name@Databaselink
for Statement.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are the 3 modes of parameter?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
Why is theta join required?
What are sql ddl commands?
What is pivot in sql?
What is the difference between mdf and ndf files?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What is self-join and what is the requirement of self-join?
What sql database should I use?
What is tuple in sql?
Is join an inner join?
Is truncate ddl or dml?
Are stored procedures compiled?
Why we use stored procedure instead of query?
