{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.001208349,0.0009490733,0.0005035086,0.001144242,0.000433284,0.002243281,0.0008863494,0.0007486562,0.01083187],"category_scores_gemma":[0.004962306,0.0003316427,0.0006048076,0.0007558845,0.0005752665,0.001905077,0.002207904,0.001480109,0.0020499],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0004894055,"about_ca_system_score_gemma":0.0006535713,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002905672,"about_ca_topic_score_gemma":0.002187154,"domain_scores_codex":[0.9991093,0.0002717588,0.00006207918,0.0001124214,0.0003508215,0.00009355163],"domain_scores_gemma":[0.9968169,0.002009938,0.0001463269,0.0004782927,0.0003761215,0.0001724774],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"simulation_or_modeling","study_design_scores_codex":[0.00682797,0.0009812847,0.02161941,0.001832761,0.0002529352,0.002413566,0.01551018,0.07907102,0.1795175,0.08105617,0.1568827,0.4540346],"study_design_scores_gemma":[0.000412998,0.0008331326,0.01657401,0.0004714368,0.00009276618,0.001282011,0.00228252,0.6366656,0.1176973,0.03409501,0.189255,0.0003382864],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.1335661,0.0008585889,0.7060009,0.001676638,0.0002125748,0.0003830197,0.007337376,0.1220416,0.02792318],"genre_scores_gemma":[0.5860554,0.0006216406,0.3875584,0.0004676463,0.00006840216,0.0004360573,0.005449045,0.009305134,0.01003834],"genre_candidate":"empirical","genre_consensus":null,"teacher_disagreement_score":0.01083187,"threshold_uncertainty_score":0.03623617,"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."}}