Chapter 6. Improving Query Performance


After completing this chapter, you will be able to:

  • Generate query plans

  • Read query plans

  • Design your database so data is stored efficiently for how it will be used

  • Use clustered and nonclustered indexes

  • Index XML columns

  • Index views

  • Defragment indexes

  • Use the Database Engine Tuning Advisor

In the previous chapter, you learned how to retrieve summary information about data in your database. SQL Server can return results, including summary information, quickly and efficiently if the data is stored appropriately in the database. This chapter will explain the different ways SQL Server stores data, how it retrieves data, and what you should consider when designing your database to achieve the most efficient performance from SQL Server.




Solid Quality Learning - Microsoft SQL Server 2005. Applied Techniques Step by Step
Microsoft SQL Server 2005: Applied Techniques Step by Step (Pro-Step by Step Developer)
ISBN: 0735623163
EAN: 2147483647
Year: 2006
Pages: 115

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net