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
Explain constraints in sql?
What is record variable?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
what is a trigger in mysql? Define different types of trigger. : Sql dba
Is mariadb nosql?
Which is faster subquery or join?
What is the advantage of index in sql?
What are string functions in sql?
What is sql performance tuning?
Write a sql query to find the names of employees that begin with ‘a’?
Is sql database free?
What is example of database?
Which are the different character-manipulation functions in sql?
Explain foreign key in sql?
what is a materialized view? : Sql dba