Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
OON
Starting Member
22 Posts |
 Posted - 2010-11-04 : 16:44:08
|
| HELLO, I HAVE THE FOLLOWING QUERY TO PULL SOME DATA. HOWEVER IT TAKES FOREVER. PLEASE LET ME KNOW IF THERE' ANYTHING I'M DOING WRONG. THANKS!!!SELECT DISTINCT PAT.PAT_NAME,MBR.INDV_HRN AS MEM_MRN,FCF.MED_REC,PAT.HOME_PHONE,PAT.WORK_PHONE,FCF.INDV_RES_PHN,FCF.INDV_WRK_PHN,FCF.NDC_NO,FCF.NDC_SPECIALTY,FCF.DISP_DT,FCF.QTY,FCF.DAYS_SUPPLY,FCF.AGE,FCF.PHYS_NAME AS DISP_PROV,MBR.PRIM_PRVD_DISPL_NM AS PRIM_PRVDR,SER1.PROV_NAME AS AUTH_PROV,MBR.home_fac_nm AS HOME_FAC,ORD.ORDERING_DATE,DEP.DEPARTMENT_NAME,DEP.SPECIALTY AS DEP_SPECLTY--ORD.PAT_LOC_ID, -- (LOOKUP)--ORD.AUTHRZING_PROV_ID,--ORD.PAT_ID,--ORD.ORD_PROV_ID,--SER2.PROV_NAME AS ORD_PROV,--FCF.PHNM_DISPL_NM,--MBR.GRP_ID AS MEM_GROUP_ID,--MBR.FAML_SUBSCR_ID AS SUBSCR_MRN,--MBR.SGRP_ID AS MEM_SUBGRP_IDFROM FILLS_CLAIMS_FINAL FCFLEFT JOIN CLARITY.PATIENT PAT ON FCF.MED_REC = PAT.PAT_MRN_IDLEFT JOIN CLARITY.ORDER_MED ORD ON PAT.PAT_ID = ORD.PAT_IDLEFT JOIN CM.MBR_DEMOG MBR ON FCF.MED_REC = MBR.INDV_HRNLEFT JOIN CM.KDINDV1V K ON MBR.INDV_HRN = K.INDV_HRN LEFT JOIN CLARITY.CLARITY_SER SER1 ON ORD.AUTHRZING_PROV_ID = SER1.PROV_IDLEFT JOIN CLARITY.CLARITY_DEP DEP ON ORD.PAT_LOC_ID = DEP.DEPARTMENT_ID--INNER JOIN CLARITY.CLARITY_SER SER2 ON ORD.ORD_PROV_ID = SER2.PROV_IDWHEREK.INDV_DECSED_FL = 'N' ANDMBR.AS_OF_MTH = '201010' --(SHOULD BE AS OF END OF REPORTING PERIOD)ORDER BY MEM_MRN |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2010-11-04 : 17:26:18
|
| Since we don't know anything about your data or tables or indexes or anything it's next to impossible to tell.But I can tell you that some of your left joins are actually inner joins based on your where clause. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
SLOOOOW QUERY - HELP!!!