Check for "EXPLAIN PLAN".

how can we find the select statement is indexed or not?

Question Posted / raji_4u

Answer Posted / raji_4u

Is This Answer Correct ?

16 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is the size of partition table?

1048

Is there any restriction on the use of union in embedded sql?

1157

what is online transaction processing (oltp)? : Sql dba

994

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1080

Can we call dml statement in function?

1055

what are the different tables present in mysql? : Sql dba

984

What does count (*) mean?

928

What are the commands used in sql?

1079

what are the different type of sql's statements ? : Sql dba

926

What are the types of queries in sql?

1086

What is sqlcommand?

1029

what are properties of a transaction? : Sql dba

1094

What is primary key and foreign key with example?

932

what is 'mysqlcheck'? : Sql dba

1013

What are the popular database management systems in the it industry?

999