java sql 查询50条数据 1.700秒 算快吗
sql 语句如下:
select *
from (select t.user_id,
ent_name,
decl_reg_no,
ori_reg_no,
linkman,
linkman_photo,
mobile_telephone,
electrograph,
ent_address,
email,
f_gethuifangdate(t.user_id, t.corp_code) as reg,
account_total,
oper_user,
to_char(oper_date, 'yyyy-mm-dd') as oper,
linkman2,
linkman_photo2,
ent_namesimple,
user_code,
t.corp_code,
lihua_account,
balance_date,
arrearage_date,
client_type,
deposit,
nvl(fee_total, 0) as qiankuan_date,
f_getbalamode(charge_type) as charge_type,
liushi,
officeno,
a.cnum,
f_getqiankuandate(t.user_id, t.corp_code) as day,
officeno1,
liushicause,
f_getHandler(t.handler, corp_code) as handler,
to_char(cause_date, 'yyyy-mm-dd') as ca,
ent_bankaccount,
ts_memo,
Finance_ren,
Finance_tel,
legal,
Legal_tel,
Trade_address,
Trade_tel,
Trade_fax,
Trade_linker,
Trade_linker_tel,
Trade_legal,
Trade_legal_tel,
min_account,
sub_account,
member_type,
soru,
dijiao
from (select user_id, count(*) as cnum
from (select user_id
from hdyw_ywdjmx
where fee_status = '2'
and flow_status <> '7'
and (cd_flag is null or cd_flag = '0')
and corp_code = 'hd'
union all
select user_id
from hdyw_ywdjmx_archives
where fee_status = '2'
and (flow_status <> '7')
and (cd_flag is null or cd_flag = '0')
and corp_code = 'hd')
group by user_id) a,
(select user_id,
sum(fee_total) as fee_total,
sum(soru) as soru,
sum(dijiao) as dijiao
from (select pay_entid as user_id,
sum((sub_charge + t.ori_charge +
f_getFareNum(yw_id, '3') +
f_getfare(yw_id, '1') + express_fare +
other_fare)) as fee_total,
sum(sub_charge + t.ori_charge +
f_getFareNum(yw_id, '2')) as soru,
sum(f_getfare(yw_id, '1') +