Table Structures and Indexing
When it comes to tuning your database structures, you must maintain a balance between doing too much and doing too little. Indexing strategies are a great example of this. If you don’t use indexes enough, searches will be slow, as the query processor could have to read every row of every table for every query. Use too many indexes, and modifying data could take too long, as indexes have to be maintained. Balance is the key, kind of like matching the amount of fluid to the size of the glass.
KeywordsUnique Constraint Unique Index Table Structure Cluster Index Data Page
Unable to display preview. Download preview PDF.