17,377
社区成员
发帖
与我相关
我的任务
分享
select MAIN_DOMAIN, ALEXA_RANKING, site_name, SITE_TYPE, CONTACT
from (select MAIN_DOMAIN,
ALEXA_RANKING,
site_name,
SITE_TYPE,
CONTACT,
spare_num,
row_number() over(partition by MAIN_DOMAIN order by MAIN_DOMAIN) rn
from site_alexa)
where rn = 1
and spare_num = 0
and ALEXA_RANKING >= '0'
and ALEXA_RANKING <= '1000000'
order by ALEXA_RANKING desc
select distinct MAIN_DOMAIN, ALEXA_RANKING, site_name, SITE_TYPE, CONTACT
from site_alexa
where 1 = 1
and spare_num = 0
and ALEXA_RANKING >= '0'
and ALEXA_RANKING <= '1000000'
order by ALEXA_RANKING desc
begin
dbms_stats.gather_table_stats(ownname => kailiao,
tabname => 'spd_domain',
method_opt => 'for all indexed columns',
cascade => TRUE);
end;
select MAIN_DOMAIN, ALEXA_RANKING, site_name, SITE_TYPE, CONTACT
from (select MAIN_DOMAIN,
ALEXA_RANKING,
site_name,
SITE_TYPE,
CONTACT,
spare_num,
row_number() over(partition by MAIN_DOMAIN order by MAIN_DOMAIN) rn
from site_alexa)
where rn = 1
and spare_num = 0
and ALEXA_RANKING >= '0'
and ALEXA_RANKING <= '1000000'
order by ALEXA_RANKING desc
SELECT endpoint_number, endpoint_value, ENDPOINT_ACTUAL_VALUE
FROM (SELECT endpoint_number, endpoint_value, ENDPOINT_ACTUAL_VALUE
FROM USER_HISTOGRAMS
WHERE table_name = 'spd_domain'
and column_name = 'kailiao'
ORDER BY endpoint_number)
WHERE rownum <= 20;
-- 有时分析函数用法不一定比其他的一般用法速度快,要看具体的情况。像上面的例子SQL1中多了个ORDER BY操作。
[Quote=引用楼主 fuyou001 的帖子:]
SELECT STATEMENT, GOAL = RULE Optimizer=RULE
SORT UNIQUE
TABLE ACCESS FULL
SELECT STATEMENT, GOAL = RULE Optimizer=RULE
SORT ORDER BY
WINDOW NOSORT
VIEW
WINDOW SORT PUSHED RANK
TABLE ACCESS FULL
SELECT STATEMENT, GOAL = CHOOSE Optimizer=CHOOSE
SORT UNIQUE
TABLE ACCESS FULL