| 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(+)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
