000 02117cam a22003497i 4500
001 19232077
003 APU
005 20180531140433.0
008 160816t20152015nyua 001 0 eng d
010 _a 2016439367
020 _a9781484211199 (pbk.)
035 _a(OCoLC)ocn921187576
040 _aYDXCP
_beng
_cYDXCP
_dWAN
042 _alccopycat
050 0 0 _aQA76.9.D3
_bS77 2015
082 0 4 _a005.7/585
_223
100 1 _aStrate, Jason.
_938337
245 1 0 _aExpert performance indexing in SQL server /
_cJason Strate, Grant Fritchey.
250 _a2nd ed.
260 _a[New York] :
_bApress,
_c2015.
300 _axxiii, 403 p. :
_bill. ;
_c26 cm
500 _aIncludes index.
505 0 _aIndex fundamentals -- Index storage fundamentals -- Index metadata and statistics -- XML indexes -- Spatial indexing -- Full-text indexing -- Indexing memory-optimized tables -- Indexing myths and best practices -- Index maintenance -- Indexing tools -- Indexing strategies -- Query strategies -- Monitoring indexes -- Index analysis -- Indexing methodology.
520 _a"This book is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. You'll better understand what indexes are doing in the database and what can be done to mitigate and improve their effect on performance. The final destination is a guided tour through a number of real life scenarios showing approaches you can take to investigate, mitigate, and improve the performance of your database"--Back cover.
630 0 0 _aSQL server.
_9616
650 0 _aDatabase management.
_9124
650 0 _aSQL (Computer program language)
_913
700 1 _aFritchey, Grant.
_938338
906 _a7
_bcbc
_ccopycat
_d2
_encip
_f20
_gy-gencatlg
942 _2lcc
_cBook
999 _c381334
_d381334