01What is an 'Index-Only Scan' (Covering Index)?
02Why is indexing a Boolean column (e.g., 'is_active') usually an anti-pattern?
03Why are B+ Trees preferred over standard Binary Search Trees for database indexing?
04What is the physical difference between a 'Clustered' index and a 'Non-Clustered' index?
05Which operation is recommended after a massive bulk load of data to ensure the Cost-Based Optimizer chooses the most efficient execution plan?