QUERY performanace

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Thu, 23 Jun 2005 16:46:09 -0400
Message-ID: <BAY106-F301405358A5DAADF6238FAD3EA0@phx.gbl>

Hi All,

I have been noticing whenever following query run it started taking more resources.

SELECT catgo.category_Id,catgo.CATEGORY, catgo.ENABLED_P,

catgo.MAILING_LIST_INFO,
catgo.PARENT_CATEGORY_ID, catgo.CATEGORY_TYPE, catgo.PROFILING_WEIGHT,
catgo.CATEGORY_DESCRIPTION,catgo.SORT_KEY_WITHIN_TYPE,catgo.CATEGORY_KEY,
catgo.CATEGORY_TYPE_ID, catgo.CATEGORY_NAME_IN_CONTEXT, 
catgo.CATEGORY_ABBREVIATION,

catg_hierarchy.PARENT_CATEGORY_ID from Categories catgo, (SELECT hierarchy.PARENT_CATEGORY_ID FROM CATEGORY_HIERARCHY hierarchy START WITH hierarchy.CHILD_CATEGORY_ID = 433 CONNECT BY PRIOR hierarchy.PARENT_CATEGORY_ID = hierarchy.CHILD_CATEGORY_ID) catg_hierarchy where catg_hierarchy.PARENT_CATEGORY_ID = catgo.category_Id and catgo.CATEGORY_TYPE_ID =2

Can any one please take a look how to make faster or rewrite ? thx

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jun 23 2005 - 16:55:11 CDT