2010-08-30Case-Insensitive Search
The initial installment of Use The Index, Luke explained the anatomy and explained the "slow index" phenomenon.
The last step was to create an index on LAST_NAME to avoid an unreasonable INDEX RANGE SCAN if the SUBSIDIARY_ID is present but not the EMPLOYEE_ID.
Today's installment introduces function based indexes to implement case-insensitive search.
Stay connected:
RSS Feed
Like on Facebook
Follow me on Twitter
Share at Google+
share and subscribe
RSS FeedFlattr this! Follow me on TwitterShare at Google+Like on Facebook