Query Doctor

@querydoctor.com

3 Followers 2 Following

So much inefficiency, too much yellow!
Diagram showing the unbounded index scan with the original query. Yellow records were scanned and discarded, defeating the purpose of the index.
An image of a SQL text which has filtering clauses decorated based on how, if at all, the database used the index when processing the query
Diagram for an "Index Scan" on a games table showing the relevant conditions from the query: g.genre = 'Puzzle' AND g.release_date > '2018-12-31'
Diagram showing how the index (game) handles a query filtering on the date column.