136 Part I EXAM PREPARATION continued 2. Right-click
136 Part I EXAM PREPARATION continued 2. Right-click on the table name and select Design Table from the pop-up menu. 3. Select Table and Index Properties. 4. Click on the Indexes/Keys tab. 5. Click on the New button. 6. From the drop-down list boxes, select the column on which to base the index and whether the index is to be ascending or descending. If you are creating a compound index based on a number of columns, then add additional columns as needed. 7. Select a filegroup for the storage of the index. 8. If desired, you can make the index unique, supply fill factor and pad index values, make the index clustered (default is nonclustered), and choose to not recalculate statistics for the index. 9. Close the dialog box to save the index and exit table design properties and select OK to save the changes. Create an index using the T-SQL CREATE INDEX. The following example creates a compound, nonclustered index that is 75% full: CREATE INDEX IXProductItem ON ProductOrderLine (OrderMateKey, ProductLineKey) WITH FILLFACTOR = 75 Clustered Indexing The selection of the appropriate column(s) on which to base a clustered index is important for a number of reasons. As previously mentioned, a clustered index represents the order in which the data is physically stored on the disk. For this reason, you can define only a single clustered index for any table. If you choose not to use a clustered index in a table, the data on disk will be stored in a heap. A clustered index, if present, has clustering keys that are used by all nonclustered indexes to determine the physical location of the data.
For high quality java hosting services please check java web hosting website.