{"id":"W2121195856","doi":"10.1145/1925805.1925812","title":"Exploiting uniqueness in query optimization","year":2010,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":9,"is_retracted":false,"has_abstract":true,"ca_institutions":"IBM (Canada)","funders":"","keywords":"Query optimization; Computer science; Exploit; SQL; sort; Sargable; Query by Example; Query language; Conjunctive query; Query expansion; Table (database); Relational database; Uniqueness; Theoretical computer science; Data mining; Web search query; Information retrieval; Database; Mathematics; Search engine","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.0001681738,0.00004983133,0.0000612764,0.00005846514,0.00003653357,0.00002723905,0.0001529167,0.00002622106,0.00002301865],"category_scores_gemma":[0.00004002349,0.00004301955,0.00001002131,0.0001936762,0.00001288905,0.0009818361,0.00009644622,0.00008396161,0.000007683141],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.000006995664,"about_ca_system_score_gemma":0.00002525179,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0001404489,"about_ca_topic_score_gemma":0.0003018623,"domain_scores_codex":[0.9995233,0.0000176615,0.0001223834,0.0001571965,0.00006786628,0.0001115798],"domain_scores_gemma":[0.9996035,0.00003170188,0.00003060499,0.000276736,0.00002957941,0.0000279161],"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":[7.0338e-7,0.00001184646,0.0009148826,0.000006158958,5.878594e-7,0.000008397565,0.0001645963,0.01453572,0.003400212,0.9729616,0.00003389205,0.007961399],"study_design_scores_gemma":[0.0004122508,0.00002275423,0.001127239,0.00005489195,7.054817e-7,0.00004153338,0.000309779,0.9458426,0.02590474,0.002292187,0.02357526,0.0004160168],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.01571742,0.00000538828,0.9790252,0.0001517819,0.0002604251,0.00005461234,5.997897e-7,0.0001199331,0.004664682],"genre_scores_gemma":[0.2272658,0.000003279146,0.7723981,0.0001078148,0.00003363495,0.00001314766,0.000003209287,0.000003686707,0.0001712755],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.9706694,"threshold_uncertainty_score":0.1754286,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.007625288036715054,"score_gpt":0.2320384156873776,"score_spread":0.2244131276506625,"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."}}