1.

What Are The Scenarios In Which Full Table Scans Occurs?

Answer»

1. The where clause in SELECT STATEMENT does not use either primary index or secondary index.
2. SQL Statement which uses a partial value (like or not like), in the WHERE statement.
3. SQL Statement which does not contain where clause.
4. SQL statement USING RANGE in where clause. Ex. (COL1 > 40 or col1 < =10000).

1. The where clause in SELECT statement does not use either primary index or secondary index.
2. SQL Statement which uses a partial value (like or not like), in the WHERE statement.
3. SQL Statement which does not contain where clause.
4. SQL statement using range in where clause. Ex. (col1 > 40 or col1 < =10000).


Discussion

No Comment Found

Related InterviewSolutions