| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> QUERY Tune
Hi,
select sp.page_id as page_id,one_line_item_desc, sp.page_title as page_title, sp.url_stub as Url_stub, sum(category_score) as cat_count, sum(decode(sp.meta_keywords,null,name_score,(name_score+me
ta_score))) as name_count, sum(content_score) as cont ent_count from static_pages sp, ( select page_id , 0 as category_score, score(20) as name_score, 0 as conte nt_score, 0 as meta_score from static_pages where page_t itle is not null and live_p = 't' and contains(page
_title, 'GEAR,GUIDE',20) > 0 UNION ALL select page_id,
0 as category_score, 0 as name_score, 0 as content_score, 0 a s meta_score from static_pages where page_title is not n ull and live_p = 't' and contains(meta_keywords, 'G EAR,GUIDE',20) > 0 UNION ALL select to_number(on_what_id) as page_id, weight as category_score, 0 as name_score, 0 as content_score, 0 as meta_score from site_wide_category_map where category_id in (1386,866,1068 ,1069,1286,3321,3508,8015,8289,8292) and on_which_table='st atic_pages' and approved_p='t' ) dyn where dyn.page_id = sp.page_id and (template_key != 'travel_photo
_gallery' and template_key != 'tpg_red_0703' and template_key !
= 'yde_redesign_may2003' and template_key != 'yde' and templat e_key != 'new_yde' and template_key != 'photo_gallery_template' ) group by sp.page_id, one_line_item_desc, sp.page_title, sp .url_stub order by cat_count desc, name_count desc, content_ count desc
This query is very slow,some times its hanges.Please suggest if anything you
find?
thx -Seema
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Fri Apr 02 2004 - 15:50:29 CST
 |
 |