[Solved] If a B-tree index exists on the column category, what will happen when running:SELECT * FROM products WHERE category > 'Electronics';? | SQL

SQL - Indexes and Query Performance

If a B-tree index exists on the column category, what will happen when running:
SELECT * FROM products WHERE category > 'Electronics';?

AThe index will cause the query to return no results

BThe query will ignore the index and scan the entire table

CThe database will only use the index if the query includes an equality condition

DThe index will be used to efficiently find rows where category is greater than 'Electronics'

Step-by-Step Solution

Solution:

Step 1: Understand range queries
B-tree indexes support range conditions like greater than.
Step 2: Query execution
The index helps locate the starting point and scan forward for matching rows.
Final Answer:
The index will be used to efficiently find rows where category is greater than 'Electronics' -> Option D
Quick Check:
Range queries benefit from B-tree indexes [OK]

Quick Trick: B-tree indexes speed up range queries like greater than [OK]

Common Mistakes:

Master "Indexes and Query Performance" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

If a B-tree index exists on the column category, what will happen when running: