1484239008 by Unknown
Author:Unknown
Language: eng
Format: epub
Published: 2018-08-21T07:48:43+00:00
Chapter 5 XML IndeXes
Creating a Clustered Index
With SSMS (SQL Server Management Studio), we can create a clustered
index on the ID column of the OrderSummary table, by expanding
Databases ➤ WideWorldImporters ➤ Tables ➤ Sales.OrderSummary in
Object Explorer, right-clicking the Indexes node, and selecting New index
➤ Clustered index. This will cause the New Index dialog box to be invoked, as shown in Figure 5-3.
Figure 5-3. New Index dialog box
Caution If you plan to follow later demonstrations in this chapter, do not execute the steps illustrated in Figures 5-3 and 5-4. also, avoid executing the script in Listing 5-2. If you do create the index, you will have to drop it before running further examples.
165
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Sita - Warrior of Mithila (Book 2 of the Ram Chandra Series) by Amish(51540)
The Crystal Crypt by Dick Philip K(35687)
Cat's cradle by Kurt Vonnegut(13879)
Always and Forever, Lara Jean by Jenny Han(13648)
Ready Player One by Cline Ernest(12850)
The Last by Hanna Jameson(9232)
Year One by Nora Roberts(8482)
Persepolis Rising by James S. A. Corey(8273)
The remains of the day by Kazuo Ishiguro(7564)
Dark Space: The Second Trilogy (Books 4-6) (Dark Space Trilogies Book 2) by Jasper T. Scott(7379)
Red Rising by Pierce Brown(7339)
Never let me go by Kazuo Ishiguro(7142)
The handmaid's tale by Margaret Atwood(6866)
The Circle by Dave Eggers(6264)
Legacy by Ellery Kane(5948)
The Testaments by Margaret Atwood(5787)
Frank Herbert's Dune Saga Collection: Books 1 - 6 by Frank Herbert(5744)
Pandemic (The Extinction Files Book 1) by A.G. Riddle(5594)
Six Wakes by Mur Lafferty(5207)
