Anindex scanis a database operation thatquickly locates table blocksusing anindexrather than scanning the entire table. It significantly improves query performance.
Example Usage:
sql
SELECT * FROM Employees WHERE EmployeeID = 105;
If EmployeeID isindexed, the database uses anindex scantoquickly find the record.
Why Other Options Are Incorrect:
Option A (Binary search) (Incorrect):A searching algorithm, but not a database operation.
Option B (Table scan) (Incorrect):Scans theentire table, which isslowerthan an index scan.
Option C (Fan-out) (Incorrect):Refers tobranching in B-Treesbut doesnot locate table blocks directly.
Thus, the correct answer isIndex scan, as it efficiently locates table blocks.
[Reference:Database Indexing and Query Optimization​., ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit