how can we find the select statement is indexed or not?
Answer Posted / raji_4u
Check for "EXPLAIN PLAN".
| Is This Answer Correct ? | 16 Yes | 2 No |
Post New Answer View All Answers
What is the size of partition table?
Is there any restriction on the use of union in embedded sql?
what is online transaction processing (oltp)? : Sql dba
what is the difference between rownum pseudo column and row_number() function? : Sql dba
Can we call dml statement in function?
what are the different tables present in mysql? : Sql dba
What does count (*) mean?
What are the commands used in sql?
what are the different type of sql's statements ? : Sql dba
What are the types of queries in sql?
What is sqlcommand?
what are properties of a transaction? : Sql dba
What is primary key and foreign key with example?
what is 'mysqlcheck'? : Sql dba
What are the popular database management systems in the it industry?