{"id":"https://openalex.org/W4414245092","doi":"https://doi.org/10.14778/3750601.3760521","title":"Still Asking: How Good Are Query Optimizers, Really?","display_name":"Still Asking: How Good Are Query Optimizers, Really?","publication_year":2025,"publication_date":"2025-08-01","ids":{"openalex":"https://openalex.org/W4414245092","doi":"https://doi.org/10.14778/3750601.3760521"},"language":"en","primary_location":{"id":"doi:10.14778/3750601.3760521","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3750601.3760521","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","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/A5046213289","display_name":"Viktor Leis","orcid":"https://orcid.org/0000-0001-5676-8017"},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Viktor Leis","raw_affiliation_strings":["Technische Universit\u00e4t M\u00fcnchen, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen, Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5032925225","display_name":"Andrey Gubichev","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Andrey Gubichev","raw_affiliation_strings":["Databricks, USA"],"affiliations":[{"raw_affiliation_string":"Databricks, USA","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088121175","display_name":"Atanas Mirchev","orcid":null},"institutions":[{"id":"https://openalex.org/I1319473763","display_name":"Volkswagen Group (Germany)","ror":"https://ror.org/01f3bhg26","country_code":"DE","type":"company","lineage":["https://openalex.org/I1319473763"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Atanas Mirchev","raw_affiliation_strings":["Volkswagen Group, Germany"],"affiliations":[{"raw_affiliation_string":"Volkswagen Group, Germany","institution_ids":["https://openalex.org/I1319473763"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5058712681","display_name":"Peter Boncz","orcid":"https://orcid.org/0000-0001-6256-0140"},"institutions":[{"id":"https://openalex.org/I1341640284","display_name":"Centrum Wiskunde & Informatica","ror":"https://ror.org/00x7ekv49","country_code":"NL","type":"facility","lineage":["https://openalex.org/I1341640284","https://openalex.org/I2800991832"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Peter Boncz","raw_affiliation_strings":["CWI, Netherlands"],"affiliations":[{"raw_affiliation_string":"CWI, Netherlands","institution_ids":["https://openalex.org/I1341640284"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5105817801","display_name":"Alfons Kemper","orcid":"https://orcid.org/0009-0003-9066-271X"},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Alfons Kemper","raw_affiliation_strings":["Technische Universit\u00e4t M\u00fcnchen, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen, Germany","institution_ids":["https://openalex.org/I62916508"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101880157","display_name":"Thomas Neumann","orcid":"https://orcid.org/0000-0001-5787-142X"},"institutions":[{"id":"https://openalex.org/I62916508","display_name":"Technical University of Munich","ror":"https://ror.org/02kkvpp62","country_code":"DE","type":"education","lineage":["https://openalex.org/I62916508"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Thomas Neumann","raw_affiliation_strings":["Technische Universit\u00e4t M\u00fcnchen, Germany"],"affiliations":[{"raw_affiliation_string":"Technische Universit\u00e4t M\u00fcnchen, Germany","institution_ids":["https://openalex.org/I62916508"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5046213289"],"corresponding_institution_ids":["https://openalex.org/I62916508"],"apc_list":null,"apc_paid":null,"fwci":2.9775,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.92706517,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":98,"max":99},"biblio":{"volume":"18","issue":"12","first_page":"5531","last_page":"5536"},"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.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9958999752998352,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/benchmarking","display_name":"Benchmarking","score":0.795199990272522},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.7475000023841858},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.745199978351593},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6625999808311462},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.40400001406669617},{"id":"https://openalex.org/keywords/estimation","display_name":"Estimation","score":0.38850000500679016},{"id":"https://openalex.org/keywords/order","display_name":"Order (exchange)","score":0.3684999942779541},{"id":"https://openalex.org/keywords/cardinal-number","display_name":"Cardinal number (linguistics)","score":0.35760000348091125}],"concepts":[{"id":"https://openalex.org/C86251818","wikidata":"https://www.wikidata.org/wiki/Q816754","display_name":"Benchmarking","level":2,"score":0.795199990272522},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.7475000023841858},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.745199978351593},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6983000040054321},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6625999808311462},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.40400001406669617},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.39579999446868896},{"id":"https://openalex.org/C96250715","wikidata":"https://www.wikidata.org/wiki/Q965330","display_name":"Estimation","level":2,"score":0.38850000500679016},{"id":"https://openalex.org/C182306322","wikidata":"https://www.wikidata.org/wiki/Q1779371","display_name":"Order (exchange)","level":2,"score":0.3684999942779541},{"id":"https://openalex.org/C2778408900","wikidata":"https://www.wikidata.org/wiki/Q1329258","display_name":"Cardinal number (linguistics)","level":2,"score":0.35760000348091125},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3391999900341034},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32679998874664307},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.32519999146461487},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.31859999895095825},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.30730000138282776},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.2928999960422516},{"id":"https://openalex.org/C156340839","wikidata":"https://www.wikidata.org/wiki/Q2704791","display_name":"Enumeration","level":2,"score":0.2687000036239624},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.265500009059906},{"id":"https://openalex.org/C37381756","wikidata":"https://www.wikidata.org/wiki/Q20203288","display_name":"Representativeness heuristic","level":2,"score":0.25999999046325684},{"id":"https://openalex.org/C143724316","wikidata":"https://www.wikidata.org/wiki/Q312468","display_name":"Series (stratigraphy)","level":2,"score":0.2567000091075897}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3750601.3760521","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3750601.3760521","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":28,"referenced_works":["https://openalex.org/W1991271936","https://openalex.org/W2143672210","https://openalex.org/W2396309311","https://openalex.org/W2613226836","https://openalex.org/W2727863938","https://openalex.org/W2755385361","https://openalex.org/W2794645646","https://openalex.org/W2948177721","https://openalex.org/W2963066364","https://openalex.org/W2970148517","https://openalex.org/W2970204999","https://openalex.org/W3000656992","https://openalex.org/W3013555795","https://openalex.org/W3094660140","https://openalex.org/W3097225903","https://openalex.org/W3099273181","https://openalex.org/W3111141572","https://openalex.org/W3197977787","https://openalex.org/W4226086155","https://openalex.org/W4309672192","https://openalex.org/W4386128208","https://openalex.org/W4386128230","https://openalex.org/W4386148280","https://openalex.org/W4396601687","https://openalex.org/W4396883573","https://openalex.org/W4402042382","https://openalex.org/W4404181355","https://openalex.org/W4405417271"],"related_works":[],"abstract_inverted_index":{"This":[0],"retrospective":[1],"revisits":[2],"our":[3],"2015":[4],"PVLDB":[5],"paper":[6],"How":[7],"Good":[8],"Are":[9],"Query":[10],"Optimizers,":[11],"Really?,":[12],"which":[13],"challenged":[14],"the":[15,27,42,63,85,109,124],"prevailing":[16],"notion":[17],"that":[18,55],"query":[19,68,121],"optimization":[20,122],"was":[21],"a":[22,34,94],"solved":[23],"problem.":[24],"By":[25],"designing":[26],"Join":[28],"Order":[29],"Benchmark":[30],"(JOB)":[31],"and":[32,49,61,73,81,91,103,113,127,135],"conducting":[33],"series":[35],"of":[36,44,96,111],"systematic":[37],"experiments,":[38],"we":[39],"empirically":[40],"disentangled":[41],"contributions":[43],"plan":[45],"enumeration,":[46],"cost":[47,71],"modeling,":[48],"cardinality":[50,56,89],"estimation.":[51],"Our":[52],"findings":[53],"showed":[54],"estimation":[57,90],"errors":[58],"are":[59],"widespread":[60],"often":[62],"dominant":[64],"factor":[65],"behind":[66],"poor":[67],"plans,":[69],"while":[70],"models":[72],"enumeration":[74],"strategies":[75],"matter":[76],"comparatively":[77],"less.":[78],"The":[79],"benchmark":[80],"methodology":[82],"helped":[83],"refocus":[84],"community's":[86],"attention":[87],"on":[88,108],"led":[92],"to":[93],"resurgence":[95],"research":[97],"in":[98,115,120],"this":[99],"area,":[100],"including":[101],"learned":[102],"AI-based":[104],"approaches.":[105],"We":[106],"reflect":[107],"role":[110],"experiments":[112],"benchmarking":[114],"database":[116],"research,":[117],"survey":[118],"developments":[119],"over":[123],"past":[125],"decade,":[126],"discuss":[128],"open":[129],"challenges":[130],"around":[131],"robustness,":[132],"adaptive":[133],"execution,":[134],"realistic":[136],"workloads.":[137]},"counts_by_year":[{"year":2026,"cited_by_count":2}],"updated_date":"2026-03-29T08:15:47.926485","created_date":"2025-10-10T00:00:00"}