SQL Performance Explained: everything developers need to know about SQL performance
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English German |
| Veröffentlicht: |
Wien
Winand
2012
|
| Ausgabe: | English ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltstext Inhaltsverzeichnis |
| Beschreibung: | VIII, 196 S. graph. Darst. 23 cm |
| ISBN: | 9783950307825 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV041094017 | ||
| 003 | DE-604 | ||
| 005 | 20200505 | ||
| 007 | t | ||
| 008 | 130618s2012 au d||| |||| 00||| eng d | ||
| 015 | |a 13,A17 |2 dnb | ||
| 016 | 7 | |a 1024368769 |2 DE-101 | |
| 020 | |a 9783950307825 |c kart. : EUR 29.95 (DE) (freier Pr.), EUR 29.95 (AT) (freier Pr.), sfr 39.90 (freier Pr.), £ 26.99 |9 978-3-9503078-2-5 | ||
| 024 | 3 | |a 9783950307825 | |
| 035 | |a (OCoLC)840903113 | ||
| 035 | |a (DE-599)DNB1024368769 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 1 | |a eng |h ger | |
| 044 | |a au |c XA-AT | ||
| 049 | |a DE-83 |a DE-739 | ||
| 082 | 0 | |a 005.7565 |2 22/ger | |
| 084 | |a ST 271 |0 (DE-625)143639: |2 rvk | ||
| 084 | |a 004 |2 sdnb | ||
| 100 | 1 | |a Winand, Markus |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a SQL Performance Explained |b everything developers need to know about SQL performance |c Markus Winand |
| 250 | |a English ed. | ||
| 264 | 1 | |a Wien |b Winand |c 2012 | |
| 300 | |a VIII, 196 S. |b graph. Darst. |c 23 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a SQL |0 (DE-588)4134010-3 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a SQL |0 (DE-588)4134010-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 775 | 0 | 8 | |i Parallele Sprachausgabe |n deutsch |a Winand, Markus |t SQL Performance Explained3 |
| 856 | 4 | 2 | |m X:MVB |q text/html |u http://deposit.dnb.de/cgi-bin/dokserv?id=4074929&prov=M&dok_var=1&dok_ext=htm |3 Inhaltstext |
| 856 | 4 | 2 | |m DNB Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=026070547&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 943 | 1 | |a oai:aleph.bib-bvb.de:BVB01-026070547 | |
Datensatz im Suchindex
| _version_ | 1806325094759268352 |
|---|---|
| adam_text |
IMAGE 1
CONTENTS
PREFACE VI
1. ANATOMY O F AN INDEX L
THE INDEX LEAF NODES 2
THE SEARCH TREE (B-TREE) 4
SLOW INDEXES, PART I 6
2. THE WHERE CLAUSE 9
THE EQUALITY OPERATOR 9
PRIMARY KEYS 10
CONCATENATED INDEXES 12
SLOW INDEXES, PART II 18
FUNCTIONS 24
CASE-INSENSITIVE SEARCH USING UPPER O R LOWER 2 4
USER DEFINED FUNCTIONS 2 9
OVER INDEXING 3 1
PARAMETERIZED QUERIES 3 2
SEARCHING F O R RANGES 39
GREATER, LESS AND BETWEEN 39
INDEXING LIKE FILTERS 45
INDEX MERGE 49
PARTIAL INDEXES 51
NULL IN THE ORACLE DATABASE 53
INDEXING NULL 54
NOT NULL CONSTRAINTS 56
EMULATING PARTIAL INDEXES 6 0
OBFUSCATED CONDITIONS 6 2
DATE TYPES 62
NUMERIC STRINGS 68
COMBINING COLUMNS 70
SMART LOGIC 11
MATH 77
I V
HTTP://D-NB.INFO/1024368769
IMAGE 2
3. PERFORMANCE AND SCALABILITY 7 9
PERFORMANCE IMPACTS O F DATA VOLUME 80
PERFORMANCE IMPACTS O F SYSTEM LOAD 85
RESPONSE TIME AND T H R O U G H P U T 87
4. THE JOIN OPERATION 9 1
NESTED LOOPS 9 2
HASH JOIN 101
SORT MERGE 109
5. CLUSTERING DATA I L L
INDEX FILTER-PREDICATES USED INTENTIONALLY 112
INDEX-ONLY SCAN 116
INDEX-ORGANIZED TABLES 1 2 2
6. SORTING AND GROUPING 129
INDEXING ORDER BY 130
INDEXING ASC, DESC AND NULLS FIRST/LAST 134
INDEXING GROUP BY 1 3 9
7. PARTIAL RESULTS 143
QUERYING TOP-N ROWS 143
PAGING THROUGH RESULTS 1 4 7
USING W I N D O W FUNCTIONS F O R PAGINATION 1 5 6
8. M O D I F Y I N G DATA 1 5 9
INSERT 159
DELETE 162
UPDATE 1 6 3
A. EXECUTION PLANS 165
ORACLE DATABASE 1 6 6
POSTGRESQL 172
SQL SERVER 180
MYSQL 188
INDEX 193
V |
| any_adam_object | 1 |
| author | Winand, Markus |
| author_facet | Winand, Markus |
| author_role | aut |
| author_sort | Winand, Markus |
| author_variant | m w mw |
| building | Verbundindex |
| bvnumber | BV041094017 |
| classification_rvk | ST 271 |
| ctrlnum | (OCoLC)840903113 (DE-599)DNB1024368769 |
| dewey-full | 005.7565 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.7565 |
| dewey-search | 005.7565 |
| dewey-sort | 15.7565 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| edition | English ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>00000nam a2200000 c 4500</leader><controlfield tag="001">BV041094017</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20200505</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">130618s2012 au d||| |||| 00||| eng d</controlfield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">13,A17</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">1024368769</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9783950307825</subfield><subfield code="c">kart. : EUR 29.95 (DE) (freier Pr.), EUR 29.95 (AT) (freier Pr.), sfr 39.90 (freier Pr.), £ 26.99</subfield><subfield code="9">978-3-9503078-2-5</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9783950307825</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)840903113</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)DNB1024368769</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="1" ind2=" "><subfield code="a">eng</subfield><subfield code="h">ger</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">au</subfield><subfield code="c">XA-AT</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-83</subfield><subfield code="a">DE-739</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7565</subfield><subfield code="2">22/ger</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 271</subfield><subfield code="0">(DE-625)143639:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">004</subfield><subfield code="2">sdnb</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Winand, Markus</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">SQL Performance Explained</subfield><subfield code="b">everything developers need to know about SQL performance</subfield><subfield code="c">Markus Winand</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">English ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Wien</subfield><subfield code="b">Winand</subfield><subfield code="c">2012</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">VIII, 196 S.</subfield><subfield code="b">graph. Darst.</subfield><subfield code="c">23 cm</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SQL</subfield><subfield code="0">(DE-588)4134010-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="775" ind1="0" ind2="8"><subfield code="i">Parallele Sprachausgabe</subfield><subfield code="n">deutsch</subfield><subfield code="a">Winand, Markus</subfield><subfield code="t">SQL Performance Explained3</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">X:MVB</subfield><subfield code="q">text/html</subfield><subfield code="u">http://deposit.dnb.de/cgi-bin/dokserv?id=4074929&prov=M&dok_var=1&dok_ext=htm</subfield><subfield code="3">Inhaltstext</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">DNB Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=026070547&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="943" ind1="1" ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-026070547</subfield></datafield></record></collection> |
| id | DE-604.BV041094017 |
| illustrated | Illustrated |
| indexdate | 2024-08-03T00:44:09Z |
| institution | BVB |
| isbn | 9783950307825 |
| language | English German |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-026070547 |
| oclc_num | 840903113 |
| open_access_boolean | |
| owner | DE-83 DE-739 |
| owner_facet | DE-83 DE-739 |
| physical | VIII, 196 S. graph. Darst. 23 cm |
| publishDate | 2012 |
| publishDateSearch | 2012 |
| publishDateSort | 2012 |
| publisher | Winand |
| record_format | marc |
| spelling | Winand, Markus Verfasser aut SQL Performance Explained everything developers need to know about SQL performance Markus Winand English ed. Wien Winand 2012 VIII, 196 S. graph. Darst. 23 cm txt rdacontent n rdamedia nc rdacarrier SQL (DE-588)4134010-3 gnd rswk-swf SQL (DE-588)4134010-3 s DE-604 Parallele Sprachausgabe deutsch Winand, Markus SQL Performance Explained3 X:MVB text/html http://deposit.dnb.de/cgi-bin/dokserv?id=4074929&prov=M&dok_var=1&dok_ext=htm Inhaltstext DNB Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=026070547&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Winand, Markus SQL Performance Explained everything developers need to know about SQL performance SQL (DE-588)4134010-3 gnd |
| subject_GND | (DE-588)4134010-3 |
| title | SQL Performance Explained everything developers need to know about SQL performance |
| title_auth | SQL Performance Explained everything developers need to know about SQL performance |
| title_exact_search | SQL Performance Explained everything developers need to know about SQL performance |
| title_full | SQL Performance Explained everything developers need to know about SQL performance Markus Winand |
| title_fullStr | SQL Performance Explained everything developers need to know about SQL performance Markus Winand |
| title_full_unstemmed | SQL Performance Explained everything developers need to know about SQL performance Markus Winand |
| title_short | SQL Performance Explained |
| title_sort | sql performance explained everything developers need to know about sql performance |
| title_sub | everything developers need to know about SQL performance |
| topic | SQL (DE-588)4134010-3 gnd |
| topic_facet | SQL |
| url | http://deposit.dnb.de/cgi-bin/dokserv?id=4074929&prov=M&dok_var=1&dok_ext=htm http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=026070547&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT winandmarkus sqlperformanceexplainedeverythingdevelopersneedtoknowaboutsqlperformance |