SQL Performance Tips (@sqlperftips) 's Twitter Profile
SQL Performance Tips

@sqlperftips

Tips to get best SQL performance.
Covering all major SQL databases.
sql-performance-explained.com is my book.

ID: 287049865

linkhttp://SQL-Performance-Explained.com/l/ calendar_today24-04-2011 06:36:45

4,4K Tweet

54,54K Followers

2 Following

SQL Performance Tips (@sqlperftips) 's Twitter Profile Photo

For this WHERE, what index to create? WHERE subsidiary_id = 42 AND last_name LIKE '%INA%' Is (subsidiary_id) enough or should it be (subsidiary_id, last_name)? use-the-index-luke.com/sql/clustering…