Web Hosting Java Blog

Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 135 FIGURE 3.4 Illustration of the B-tree structure used for index storage. If a clustered index has not been defined for a given table, then the data is stored in a heap. A data heap does not maintain data in any particular order; it simply stores the data in the order in which it is entered. In some applications, where data is never retrieved in any particular order on a regular basis, this might actually be advantageous. Indexes can be created using the T-SQL CREATE INDEX command. When you use the Enterprise Manager to create an index, you must access the table design and then reveal the table properties. Step by Step 3.4 shows you how to use the Enterprise Manager to create an index. STEP BY STEP 3.4 Selection of Index Creation from the Enterprise Manager 1. From the Enterprise Manager, select the table with which the index will be associated. continues

For high quality java hosting services please check java web hosting website.