QUERY performanace

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

Other related posts: