{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.006538642,0.002306471,0.001623668,0.00224892,0.001026059,0.006528487,0.00326757,0.001168907,0.08954353],"category_scores_gemma":[0.02037482,0.00191989,0.0009883252,0.002875742,0.0004767078,0.004534443,0.002016125,0.002437032,0.09498234],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001822565,"about_ca_system_score_gemma":0.004344726,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.009478444,"about_ca_topic_score_gemma":0.007558185,"domain_scores_codex":[0.9922298,0.001746222,0.0005666041,0.0006188573,0.004388425,0.0004502259],"domain_scores_gemma":[0.9925288,0.002568115,0.0002439389,0.00203384,0.002305559,0.0003197618],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"not_applicable","study_design_gemma":"not_applicable","study_design_scores_codex":[0.0005932586,0.0002081703,0.0007389024,0.0003232315,0.00006585042,0.0000574837,0.0001324809,0.009778135,0.007020145,0.005936774,0.6078715,0.367274],"study_design_scores_gemma":[0.0004482204,0.0003505445,0.003048619,0.0002174419,0.0000968935,0.0004541012,0.0002133393,0.2099876,0.02929127,0.01921363,0.7364609,0.0002174792],"study_design_candidate":"not_applicable","study_design_consensus":"not_applicable","genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.005470422,0.002971264,0.4412862,0.002344021,0.000410836,0.001803881,0.0192263,0.4355486,0.09093843],"genre_scores_gemma":[0.07661677,0.003726129,0.6368237,0.002268583,0.0005225622,0.002624207,0.06385776,0.09495006,0.1186102],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.08954353,"threshold_uncertainty_score":0.2995529,"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."}}