It depends on your frequently run queries. Are you retrieving data filtered on a single country/last name (point lookup) or you scanning a range of rows based on country/last name? Gather your frequently run queries and look at the execution plans to figure out which one will best serve your purpose.
Satish Kartan www.sqlfood.com
No comments:
Post a Comment