Here's the tkprof output for a query that's running extremely slowly (WARNING: it's long :-) ): SELECT mbr_comment_idn, mbr_crt_dt, mbr_data_source, mbr_dol_bl_rmo_ind, mbr_dxcg_ctl_member, mbr_employment_start_dt, mbr_employment_term_dt, mbr_entity_active, mbr_ethnicity_idn, mbr_general_health_status_code, mbr_hand_dominant_code, mbr_h...
Hi, I have a multi-table SELECT query which compares column values with itself like below: SELECT * FROM table1 t1,table2 t2 WHERE t1.col1=t2.col1 --Different tables,So OK. AND t1.col1=t1.col1 --Same tables?? AND t2.col1=t2.col1 --Same tables?? This seems redundant to me. My query is, Will removing them ha...
I have a query that is running slowly. I know generally to make performance faster, limit joins, and try to use procs instead of straight queries. Due to business rules, I cannot use procs. I've already cut the number of joins as much as I can think of. What's the next step in query tuning? ...