sql如下:
select t.description as "description",
f.area_no as "area_no",
f.city_no as "city_no",
f.city_name as "city_name",
f.town_no as "town_no",
f.town_name as "town_name",
f.channel_no3 as "channel_no3",
f.channel_name3 as "channel_name3",
nvl(sum(f.day_value), 0) as "month_total",
nvl(sum(f.day_value_lm), 0) as "last_month_value"
from dm.dm_td_dev_Analysis_depart f, dmcode.dmcode_area t
where acct_date <= 20100801
and acct_date >= 20100801
and f.flag = 01
and t.area_no = f.area_no
group by f.channel_no3,
f.channel_name3,
f.town_no,
f.town_name,
f.city_no,
f.city_name,
f.area_no,
t.description,
t.idx_no
order by t.idx_no, f.city_no, f.town_no, f.channel_no3这个表 建了2个索引,一个是acct_date 另一个是acct_date和flag 组合的,但是执行的时候怎么不走索引呢???
页面展现的太慢了
select t.description as "description",
f.area_no as "area_no",
f.city_no as "city_no",
f.city_name as "city_name",
f.town_no as "town_no",
f.town_name as "town_name",
f.channel_no3 as "channel_no3",
f.channel_name3 as "channel_name3",
nvl(sum(f.day_value), 0) as "month_total",
nvl(sum(f.day_value_lm), 0) as "last_month_value"
from dm.dm_td_dev_Analysis_depart f, dmcode.dmcode_area t
where acct_date <= 20100801
and acct_date >= 20100801
and f.flag = 01
and t.area_no = f.area_no
group by f.channel_no3,
f.channel_name3,
f.town_no,
f.town_name,
f.city_no,
f.city_name,
f.area_no,
t.description,
t.idx_no
order by t.idx_no, f.city_no, f.town_no, f.channel_no3这个表 建了2个索引,一个是acct_date 另一个是acct_date和flag 组合的,但是执行的时候怎么不走索引呢???
页面展现的太慢了
and acct_date >= 20100801
你这个语句什么意思?
and acct_date >= '20100801'
and f.flag = '01'