Improve performance by creating a clustered index: A clustered index physically orders the data in a table based on a single or composite column. The records stored in a table without a clustered index are not in a specific physical order. Whenever you need to query the column or columns used for the clustered index, SQL Server helps you sequentially read the data in a clustered index an extent (8 data pages, or 64K) at a time. This makes it easy for the disk subsystem to read the data quickly from disk, especially if there is a lot of data to be retrieved | Collaborate Chapter 3 Knowledge Byte In this section you will learn about Creating an XML document Storing XML data in XML columns Using XQuery Creating an Extensible Markup Language XML Document Read the following topic in the Appendix of the book Querying and Managing Data Using SQL Server 2005 Extensible Markup Language XML Storing XML Data in XML Columns Read the following topic in the Manipulating the XML Data section of Chapter 5 of the book Querying and Managing Data Using SQL Server 2005 Storing XML Data in XML columns Using XQuery Read the following topic in the section Manipulating the XML Data of Chapter 5 of the book Querying and Managing Data Using SQL Server 2005 Using XQuery NIIT Querying Managing and Administering Databases Using SQL Server 2005 .
