Which execution plan operator typically indicates that an index is not being used and a full scan is occurring?
SQL Data AnalystHard
SQL Data Analyst — Hard
Which execution plan operator typically indicates that an index is not being used and a full scan is occurring?
Explanation
When the execution plan operator "Table Scan / Seq Scan" appears, it indicates that an index is not being used, and a full scan of the table is being performed. This means every row in the table is being examined.
