DatabaseQuery Optimization
KW-0032

Full Table Scan

Problem
Meaning

database operation where every row is read because no suitable index is used

Example

Query without index scans entire users table causing slow response

Reference
Avoid in large datasets; often indicates missing index or poor query design
Related
time complexityindexingquery plan

Built with ♥ by Sakib