Table Scan: It scans every row for finding a particular node or data. If the planner fails to use a proper index, it has to do full Table Scanning. If table has a less number of records, Table Scan is an excellent choice for query optimizer. For example, If Table has around 1000 records, Table … Continue reading Database Theory: Table Scan vs Index Scan vs Index Seek