{"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":"metacan-v3-hybrid-931329e0061c","candidate_categories":[],"consensus_categories":[],"category_scores_codex":[0.003376858,0.0009159764,0.0005207865,0.0006242536,0.0008341797,0.001251417,0.001518427,0.001159868,0.0006165821],"category_scores_gemma":[0.008938285,0.0003723742,0.0004478139,0.002014389,0.001251446,0.00187136,0.0006929586,0.001270791,0.0001729439],"about_ca_system_candidate":false,"about_ca_system_consensus":false,"about_ca_system_score_codex":0.001433872,"about_ca_system_score_gemma":0.001014333,"about_ca_topic_candidate":false,"about_ca_topic_consensus":false,"about_ca_topic_score_codex":0.01109953,"about_ca_topic_score_gemma":0.01297274,"domain_scores_codex":[0.9965115,0.001702261,0.0002012701,0.0003083886,0.0009077987,0.0003688378],"domain_scores_gemma":[0.9882039,0.008962208,0.0004287185,0.0009423972,0.001127568,0.0003351607],"domain_codex":null,"domain_gemma":null,"domain_candidate":null,"domain_consensus":null,"study_design_codex":"simulation_or_modeling","study_design_gemma":"not_applicable","study_design_scores_codex":[0.002413292,0.005733951,0.06221994,0.001701061,0.0004819311,0.005356785,0.005828123,0.6345693,0.05695983,0.01164013,0.01795943,0.1951363],"study_design_scores_gemma":[0.0005173207,0.002577416,0.03328959,0.00005914468,0.0001375785,0.001154887,0.003797634,0.8712522,0.06716165,0.006024585,0.01392699,0.0001009582],"study_design_candidate":"not_applicable","study_design_consensus":null,"genre_codex":"empirical","genre_gemma":"methods","genre_scores_codex":[0.9813115,0.0005779088,0.01215264,0.0009858395,0.00002224755,0.0001294615,0.0003303502,0.0008528508,0.0036372],"genre_scores_gemma":[0.9709481,0.0002742507,0.0273198,0.0001514919,0.00002187346,0.00003302079,0.0003145517,0.0001508921,0.0007859775],"genre_candidate":"methods","genre_consensus":null,"teacher_disagreement_score":0.01109953,"threshold_uncertainty_score":0.02206981,"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."}}