Hi All
The Query below took around 175 Secs to return 22 Rows..Any way this query
can be optimized
SELECT
Distinct(C.Company_Name) ,U.UserID , IF(U.CompanyID IS
NULL , NULL ,C.Company_Name) as Company_Name,
U.COMPANYID, U.PASSWORD,
U.INDIVIDUAL_COMPANY_NAME,
U.USER_NAME,U.FIRST_NAME,
U.LAST_NAME, U.MIDDLE_NAME,
U.EMAIL,U.PROMOTION_CODE,U.TITLE, U.DESIGNATION,
U.USER_STATUS, U.USER_APP_STATUS,
U.PHONE,U.ADDRESS, U.CREATED_ON,U.FAX, U.ZIP,
U.DEPARTMENT, U.MODIFIED_ON,
U.CITY,U.STATE, U.INDUSTRYID, U.COUNTRYID,
U.CERTIFICATIONID,U.TECHNOLOGY_AREAID,
U.HORIZONTAL_STANDARDS_EXP,
U.ROLEID,U.ROLE_OTHER, U.YEARS_OF_EXP,
U.OTHER_CERTIFICATION2,
U.PROF_MEMBERSHIP1, U.OTHER_CERTIFICATION3,
U.PROF_MEMBERSHIP2,U.OTHER_CERTIFICATION1,
U.HOURLY_RATE,
U.PROF_MEMBERSHIP3,U.WORK_PREFERENCE,
U.OTHER_CERTIFICATION4,
U.ADDITIONAL_COMMENTS,U.WELCOME_MESSAGE,
I.Industry_Name,T.Technology_Area, R.Role
FROM
User_Type_Details UTD,
User_Type_Details B , Users U ,TempGeneralSearch1 T1,Users A
LEFT JOIN Company C on (U.CompanyID = C.CompanyID)
LEFT JOIN Expert_Info EI on (U.UserID = EI.UserID)
LEFT JOIN User_Horizontal_Market UHM on (U.UserID =
UHM.UserID)
LEFT JOIN Industry I on (U.IndustryID = I.IndustryID)
LEFT JOIN Technology_Area T on (U.Technology_AreaID =
T.Technology_AreaID)
LEFT JOIN Role R on (U.RoleID = R.RoleID )
WHERE
U.UserID = UTD.UserID
AND U.User_Status='ACT' AND U.User_App_Status='APP'
AND UTD.User_TypeID IN (4,0,2,3) AND T1.TempID=117
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
