{"id":"https://openalex.org/W1824813896","doi":"https://doi.org/10.1007/978-1-4302-6742-3_1","title":"SQL Query Performance Tuning","display_name":"SQL Query Performance Tuning","publication_year":2014,"publication_date":"2014-01-01","ids":{"openalex":"https://openalex.org/W1824813896","doi":"https://doi.org/10.1007/978-1-4302-6742-3_1","mag":"1824813896"},"language":"en","primary_location":{"id":"doi:10.1007/978-1-4302-6742-3_1","doi":"https://doi.org/10.1007/978-1-4302-6742-3_1","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-6742-3_1","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SQL Server Query Performance Tuning","raw_type":"book-chapter"},"volume":{"id":"https://openalex.org/W2479662415","display_name":"SQL Server Query Performance Tuning"},"type":"book-chapter","is_traditional":true,"indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5064569577","display_name":"Grant Fritchey","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Grant Fritchey","raw_affiliation_strings":["MA, US","Grafton, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"MA, US","institution_ids":[]},{"raw_affiliation_string":"Grafton, USA","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5064569577"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":87,"max":93},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"15"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9951000213623047,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9951000213623047,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.0007999999797903001,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.000699999975040555,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/query-performance-tuning","display_name":"query performance tuning","score":0.8399999737739563},{"id":"https://openalex.org/keywords/sql-server","display_name":"SQL Server","score":0.9819999933242798},{"id":"https://openalex.org/keywords/query-optimizer","display_name":"query optimizer","score":0.6200000047683716},{"id":"https://openalex.org/keywords/query-execution","display_name":"query execution","score":0.578000009059906},{"id":"https://openalex.org/keywords/indexing","display_name":"indexing","score":0.6060000061988831},{"id":"https://openalex.org/keywords/database-design","display_name":"database design","score":0.8960000276565552},{"id":"https://openalex.org/keywords/virtual-machines","display_name":"virtual machines","score":0.7580000162124634},{"id":"https://openalex.org/keywords/cloud-database-services","display_name":"cloud database services","score":0.5370000004768372},{"id":"https://openalex.org/keywords/amazon-rds","display_name":"Amazon RDS","score":0.949999988079071}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8630217909812927},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.7324337363243103},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.711087167263031},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6729914546012878},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6546142101287842},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6033981442451477},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5673224329948425},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.5132763385772705},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.4935199022293091},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.48685067892074585},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.4764956831932068},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.45205754041671753},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.4501662850379944},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.42639321088790894},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3360501527786255},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.32969558238983154},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.21498903632164001},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.20859801769256592},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.20844081044197083}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-1-4302-6742-3_1","doi":"https://doi.org/10.1007/978-1-4302-6742-3_1","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-1-4302-6742-3_1","pdf_url":null,"source":{"id":"https://openalex.org/S4306462844","display_name":"Apress eBooks","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"ebook platform"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"SQL Server Query Performance Tuning","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W4247405402","https://openalex.org/W2474435957","https://openalex.org/W1595762401","https://openalex.org/W4237013245","https://openalex.org/W4312499454","https://openalex.org/W7126376490","https://openalex.org/W2481757031","https://openalex.org/W4230323281","https://openalex.org/W49967903","https://openalex.org/W2891942564"],"abstract_inverted_index":{"Query":[0],"performance":[1,13,42,106,115,125,161],"tuning":[2,107,126],"remains":[3,108],"an":[4,136,172],"important":[5],"part":[6],"of":[7,116,123,165],"today\u2019s":[8],"database":[9,98,118],"applications.":[10],"Yes,":[11],"hardware":[12,68],"is":[14,30,70,127],"constantly":[15],"improving.":[16],"Upgrades":[17],"to":[18,21,40,76,94,135],"SQL":[19,51,89,140],"Server\u2014especially":[20],"the":[22,33,38,48,67,114,158],"optimizer,":[23],"which":[24,36],"helps":[25],"determine":[26],"how":[27],"a":[28,79,109,132,139,145,151,177],"query":[29,34,105,124,141],"executed,":[31],"and":[32,86,100],"engine,":[35],"executes":[37],"query\u2014lead":[39],"better":[41,167,179],"all":[43],"on":[44,57],"their":[45],"own.":[46],"At":[47],"same":[49],"time,":[50],"Server":[52],"instances":[53],"are":[54,74],"being":[55],"put":[56],"virtual":[58],"machines,":[59],"either":[60],"locally":[61],"or":[62,138,176],"in":[63,129,144,160],"hosted":[64],"environments,":[65],"where":[66],"behavior":[69],"not":[71],"guaranteed.":[72],"Databases":[73],"going":[75],"platform":[77],"as":[78,83],"service":[80],"systems":[81],"such":[82],"Amazon":[84],"RDS":[85],"Windows":[87],"Azure":[88],"Database.":[90],"You":[91],"still":[92],"have":[93],"deal":[95],"with":[96],"fundamental":[97],"design":[99],"code":[101],"generation.":[102],"In":[103,155],"short,":[104],"vital":[110],"mechanism":[111],"for":[112],"improving":[113],"your":[117],"management":[119],"systems.":[120],"The":[121],"beauty":[122],"that,":[128],"many":[130],"cases,":[131,157],"small":[133],"change":[134],"index":[137],"can":[142,162],"result":[143],"far":[146],"more":[147],"efficient":[148],"application":[149],"at":[150],"very":[152],"low":[153],"cost.":[154],"those":[156],"increase":[159],"be":[163],"orders":[164],"magnitude":[166],"than":[168],"that":[169],"offered":[170],"by":[171],"incrementally":[173],"faster":[174],"CPU":[175],"slightly":[178],"optimizer.":[180]},"counts_by_year":[{"year":2021,"cited_by_count":1}],"updated_date":"2026-10-10T09:11:00.788812","created_date":"2016-06-24T00:00:00"}