Home » RDBMS Server » Server Administration » SQL performance
SQL performance [message #371871] Fri, 15 December 2000 10:38
Alan
Messages: 68
Registered: October 1999
Member
Hello All:
Is there a way to impove the performance on the following SQL, because of the additional selects in the from cluase it takes several minutes for any search.
Please help,
Thanks
Alan

SELECT
inv.projectkey ProjectKey,
obs.name BusinessUnit
owndata.sysowner SystemOwner,
domexpert.domowner DomainExpert
FROM
obs obs3,
inventory inv,
(SELECT PEOPLE.FIRSTNAME || ' ' || PEOPLE.LASTNAME domowner,
ASSIGNED_ROLES.OBJECT_ID
FROM
BE_ASSIGNED_ROLES ASSIGNED_ROLES,
BE_PEOPLE PEOPLE
WHERE
ASSIGNED_ROLES.PERSON_ID = PEOPLE.PERSON_ID
AND ASSIGNED_ROLES.ROLE_ID = '3') DOMEXPERT,
(SELECT
PEOPLE.FIRSTNAME || ' ' || PEOPLE.LASTNAME SYSOWNER,
ASSIGNED_ROLES.OBJECT_ID
FROM
BE_ASSIGNED_ROLES ASSIGNED_ROLES,
BE_PEOPLE PEOPLE
WHERE
ASSIGNED_ROLES.PERSON_ID = PEOPLE.PERSON_ID
AND ASSIGNED_ROLES.ROLE_ID = '16') OWNERDATA
WHERE
OBS3.DEPT_ID = INV_SUBSYSTEMS.SYSTEM_ID
AND INV_SUBSYSTEMS.PROJECTKEY = owndata.OBJECT_ID(+)
AND INV_SUBSYSTEMS.PROJECTKEY = domexpert.OBJECT_ID(+)
Previous Topic: BARRISTER
Next Topic: What is Jserve?
Goto Forum:
  


Current Time: Sun Dec 22 20:33:25 CST 2024