{"id":"W2041785380","doi":"10.1145/1923947.1924005","title":"Use DB2 optimization techniques to get and maintain a good query execution plan","year":2010,"lang":"en","type":"article","venue":"","topic":"Distributed and Parallel Computing Systems","field":"Computer Science","cited_by":1,"is_retracted":false,"has_abstract":true,"ca_institutions":"IBM (Canada)","funders":"","keywords":"Computer science; SQL; Query optimization; Query plan; Java; Plan (archaeology); Documentation; Sargable; Query by Example; Execution time; Work (physics); Database; Programming language; Software engineering; Information retrieval; Web search query; Search engine; Engineering","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.00445854,0.002149075,0.0008156761,0.001641849,0.0009650596,0.002948011,0.001810294,0.0007312744,0.007642318],"category_scores_gemma":[0.01085943,0.001451626,0.00125386,0.001586247,0.0009108906,0.004283064,0.003572752,0.002872156,0.005959919],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00106776,"about_ca_system_score_gemma":0.00221253,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.007394434,"about_ca_topic_score_gemma":0.005164945,"domain_scores_codex":[0.996097,0.0007377,0.0004264102,0.0007372073,0.00158797,0.0004137615],"domain_scores_gemma":[0.9944923,0.001800486,0.0004055993,0.002220576,0.000887893,0.0001932569],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"design_other","study_design_gemma":"not_applicable","study_design_scores_codex":[0.00168732,0.0004370708,0.01115083,0.001073945,0.0003952547,0.0007049886,0.002535397,0.03889769,0.08424693,0.02294802,0.1055031,0.7304195],"study_design_scores_gemma":[0.0004133807,0.0003752284,0.006438675,0.0002793374,0.0002614894,0.00126323,0.0008906028,0.4817567,0.2744879,0.04362747,0.1898513,0.000354617],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"methods","genre_scores_codex":[0.01750213,0.0003377366,0.8323144,0.0007371698,0.00007437883,0.0003139162,0.00126333,0.1363051,0.01115187],"genre_scores_gemma":[0.1642708,0.0003904789,0.7869915,0.000703938,0.00004868826,0.0003765082,0.005015807,0.03665495,0.005547316],"genre_candidate":"methods","genre_consensus":"methods","teacher_disagreement_score":0.007642318,"threshold_uncertainty_score":0.02556616,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.01433284471042477,"score_gpt":0.2351093211428254,"score_spread":0.2207764764324007,"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."}}