{"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":"codex-gemma-dda1882f352a","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.0003149205,0.0001018121,0.0001014213,0.00009194368,0.0000909977,0.0004091134,0.0002973817,0.00007873963,0.000006359629],"category_scores_gemma":[0.00004103061,0.00009008217,0.00001987632,0.0002069456,0.00001584138,0.0003672064,0.0001623721,0.0001066846,0.00001195893],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00001377404,"about_ca_system_score_gemma":0.00002601018,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0001779266,"about_ca_topic_score_gemma":0.00005445735,"domain_scores_codex":[0.9991998,0.00004591011,0.0001599893,0.0002831752,0.0001284708,0.0001826631],"domain_scores_gemma":[0.9993998,0.00005609601,0.00004610607,0.0003260268,0.00006066678,0.0001112711],"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.00001230536,0.00008764816,0.003233994,0.00002295775,0.00001586872,0.00001764609,0.0006171786,0.009321271,0.003937062,0.9583075,0.008518643,0.01590789],"study_design_scores_gemma":[0.000319552,0.0003217402,0.003417924,0.00008938184,0.000007894984,0.0002330114,0.00007049353,0.9208316,0.00556512,0.004786965,0.06362522,0.0007311666],"study_design_candidate":"theoretical_or_conceptual","study_design_consensus":null,"genre_codex":"methods","genre_gemma":"empirical","genre_scores_codex":[0.0287402,0.000003287327,0.9674989,0.0006646906,0.0002247584,0.0002146811,0.000004957266,0.00048802,0.002160479],"genre_scores_gemma":[0.6652071,0.00000146281,0.3341663,0.0003170294,0.00005951113,0.0000101781,0.00001050357,0.000004469544,0.0002233982],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.9535206,"threshold_uncertainty_score":0.394509,"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."}}