{"id":"W4414127891","doi":"10.14419/x2wqqh31","title":"Enhancing SQL Query Performance: A Case Study on Optimizing Enterprise Data Processing","year":2025,"lang":"en","type":"article","venue":"International Journal of Basic and Applied Sciences","topic":"Cloud Computing and Resource Management","field":"Computer Science","cited_by":0,"is_retracted":false,"has_abstract":true,"ca_institutions":"Red Deer Polytechnic","funders":"","keywords":"Query plan; Query optimization; SQL; Scalability; Sargable; Cardinality (data modeling); Search engine indexing; Materialized view; Query by Example","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.00142183,0.00009341419,0.0001301425,0.0003220698,0.0003112397,0.00051312,0.00163908,0.00001543005,0.000001188048],"category_scores_gemma":[0.00002457421,0.00006793764,0.00002274599,0.0002797064,0.00008652164,0.0001515323,0.0008505253,0.0001522594,9.554151e-7],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.00003333318,"about_ca_system_score_gemma":0.0001178555,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.0000107013,"about_ca_topic_score_gemma":0.000003633918,"domain_scores_codex":[0.9986755,0.00002743545,0.0003345613,0.0002924168,0.0005354015,0.0001346995],"domain_scores_gemma":[0.9993442,0.000107994,0.0002318295,0.0001865204,0.00008756627,0.00004185854],"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.00006423747,0.000644945,0.00571895,0.00004078355,0.0001668316,0.001152497,0.008423302,0.0262098,0.0006002855,0.003599824,0.0003796803,0.9529989],"study_design_scores_gemma":[0.003107696,0.001036906,0.005599277,0.001669309,0.00008589589,0.003474863,0.04574883,0.932691,0.00326582,0.000993476,0.001748773,0.0005781398],"study_design_candidate":"simulation_or_modeling","study_design_consensus":null,"genre_codex":"empirical","genre_gemma":"empirical","genre_scores_codex":[0.9171572,0.0001071167,0.07868455,0.0007340429,0.0004976258,0.00007449432,3.049506e-7,0.00001738717,0.002727335],"genre_scores_gemma":[0.9914753,0.000007222653,0.007983251,0.0003529012,0.0001236167,0.000001348727,1.024621e-7,0.000001890686,0.00005437363],"genre_candidate":"empirical","genre_consensus":"empirical","teacher_disagreement_score":0.9524207,"threshold_uncertainty_score":0.4948028,"prediction_status":"machine_predicted_unvalidated"},"machine_scores":{"provisional":true,"baseline":true,"maturity_gate_passed":false,"score_opus":0.028457097179871,"score_gpt":0.3080487626930515,"score_spread":0.2795916655131805,"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."}}