Tag - indexining

Full Table Scan vs Full Index Scan Performance

Full Table Scan vs Full Index Scan

Earlier this week, Cédric blogged about how easy we can get confused between a covering index and a full index scan in the EXPLAIN output. While a covering index (seen with EXPLAIN as Extra: Using index) is a very interesting performance optimization, a full index scan (type: index) is according to the documentation the […]

Read more