{"id":"W2141593784","doi":"10.1145/1559845.1559983","title":"Extreme visualisation of query optimizer search space","year":2009,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":6,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Computer science; Query optimization; Query by Example; SQL; Database; User-defined function; Heuristics; Sargable; Web search query; Data Transformation Services; Stored procedure; Materialized view; Data mining; Information retrieval; View; Search engine; Operating system; Database design","routes":{"ca_aff":true,"ca_fund":false,"ca_venue":false,"about_ca":false,"invisible_to_affiliation_only":false},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0001992345,0.00006218516,0.0001052813,0.00005830005,0.00003576824,0.00001623499,0.0001654947,0.00002222326,0.00003352715],"category_scores_gemma":[0.00001792252,0.0000498679,0.00002884268,0.0001915016,0.00002110558,0.0006640866,0.00005824941,0.00003866783,0.00001841693],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00001310535,"about_ca_system_score_gemma":0.00003128061,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00006041381,"about_ca_topic_score_gemma":0.000004540733,"domain_scores_codex":[0.9993147,0.0000366417,0.0001510772,0.0001708557,0.0001969445,0.000129742],"domain_scores_gemma":[0.9994398,0.00003248555,0.00004251253,0.000367332,0.0000760609,0.0000417609],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"theoretical_or_conceptual","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.000003717827,0.00002502771,0.00005993337,0.000006024864,0.000002149529,0.000002402703,0.0002383926,0.0008041164,0.007482597,0.9818606,0.0005180297,0.008997047],"study_design_scores_gemma":[0.002054638,0.001025393,0.01485782,0.0002412881,0.00001145156,0.00005601715,0.000974076,0.4341325,0.4335872,0.01372161,0.09808803,0.001249988],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.005212908,0.00005171616,0.9849821,0.0006545019,0.00007112337,0.00007746455,0.000001946657,0.00007907664,0.008869131],"genre_scores_gemma":[0.4122592,0.00001220125,0.585754,0.0001693253,0.00003996753,0.000001786395,0.000004104668,0.000002896717,0.001756495],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.9681389,"threshold_uncertainty_score":0.2033554,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.04591244616557154,"score_gpt":0.2951833316837544,"score_spread":0.2492708855181828,"validation_status":"score_only:v0-immature-baseline","note":"Baseline scores from an immature model (maturity gate not passed). Scores rank; they never assert a category."}}