{"id":"W2211823484","doi":"10.1109/icde.1994.283003","title":"Exploiting uniqueness in query optimization","year":2002,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":29,"is_retracted":false,"has_abstract":true,"ca_institutions":"University of Waterloo","funders":"","keywords":"Query optimization; Computer science; Uniqueness; Sargable; Query language; Web search query; Information retrieval; 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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.01068917,0.001051867,0.001572192,0.001696255,0.002092273,0.003774221,0.002580061,0.001586491,0.00326538],"category_scores_gemma":[0.03651726,0.001157132,0.002037274,0.00247086,0.004866657,0.01344953,0.008625708,0.002339786,0.0009151267],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00120089,"about_ca_system_score_gemma":0.002704963,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.002675796,"about_ca_topic_score_gemma":0.00212794,"domain_scores_codex":[0.9864028,0.005421584,0.001145316,0.001809561,0.003514156,0.001706686],"domain_scores_gemma":[0.9747014,0.01815338,0.001188532,0.003897669,0.001760577,0.0002984535],"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.001382447,0.0003187306,0.01807514,0.0008770272,0.0003543929,0.001677885,0.00181264,0.102045,0.03216441,0.5295329,0.008859485,0.3028999],"study_design_scores_gemma":[0.0001546371,0.0004228876,0.001699834,0.0001519346,0.0002931799,0.001369849,0.0008238982,0.3868083,0.07128573,0.5199844,0.01683036,0.0001749972],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.05555863,0.0006235853,0.9341484,0.0009579189,0.00005306808,0.0001913787,0.0001852956,0.001956421,0.006325241],"genre_scores_gemma":[0.5625144,0.0005150083,0.4322665,0.0007124821,0.0001136745,0.0002108521,0.0003822535,0.0007332153,0.002551501],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.01068917,"threshold_uncertainty_score":0.05653042,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.02719003291806306,"score_gpt":0.2186161833753887,"score_spread":0.1914261504573256,"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."}}