{"id":"W7097479410","doi":"","title":"Performance and Tuning Guide: Volume 2- Query Optimization, Query Tuning and Abstract Plans","year":2002,"lang":"en","type":"article","venue":"","topic":"Advanced Database Systems and Queries","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"","funders":"","keywords":"License; Software; Order (exchange); Volume (thermodynamics); Subject (documents)","routes":{"ca_aff":false,"ca_fund":false,"ca_venue":false,"about_ca":true,"invisible_to_affiliation_only":true},"retraction":null,"screen":null,"direct_labels":[],"prediction":{"model_version":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0001972923,0.0001430349,0.0001559433,0.00008057192,0.0002718662,0.0001157085,0.0001457678,0.00004555018,0.00008282319],"category_scores_gemma":[0.00003646169,0.0001264994,0.00001425875,0.0001441211,0.00006790787,0.001903104,0.000188138,0.00009822173,0.00001502549],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.0000155097,"about_ca_system_score_gemma":0.00001348935,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.00009416658,"about_ca_topic_score_gemma":0.00002409528,"domain_scores_codex":[0.9990004,0.00001764879,0.0002673863,0.0003369448,0.0001442606,0.0002334117],"domain_scores_gemma":[0.9993759,0.00005513506,0.00008612634,0.0003227442,0.0000552297,0.0001048914],"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.00002781397,0.0002120125,0.2285216,0.001006011,0.000154653,0.0002681894,0.01174217,0.1573319,0.002964984,0.1268945,0.07751651,0.3933597],"study_design_scores_gemma":[0.000173531,0.00003397166,0.004989686,0.00007875596,0.000002577699,0.0001080641,0.000142155,0.9487193,0.000054208,0.000009716771,0.0454664,0.0002216874],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.02073832,0.0004211074,0.9654447,0.0003230145,0.0001386251,0.00009421469,0.000007974615,0.000193239,0.01263883],"genre_scores_gemma":[0.4597662,0.001023787,0.5299432,0.0003760682,0.0001087065,0.00001305223,0.00001205036,0.00001952545,0.008737449],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.7913874,"threshold_uncertainty_score":0.5158498,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01773105680798267,"score_gpt":0.2202552170626035,"score_spread":0.2025241602546209,"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."}}