advancedDatabase Optimization Techniques
How does a type mismatch in a WHERE clause silently kill index usage?
Tests whether you know an implicit conversion on the indexed column forces a full scan even though an index exists.
This is a Pro question
Sign in, then upgrade to Pro or Power to unlock this question and the full Interview Prep bank.
How does a type mismatch in a WHERE clause silently kill index usage?