表的查询检索速度
我问一下对于5张表的检索可以用下面的语句吗?
SELECT "t_manager"."khjl_id",
"t_manager"."khjl_nm",
"t_account"."zh",
"t_cz"."czmc",
"t_account"."dqye",
"t_account"."dqrq",
"t_unit"."dwbh",
"t_unit"."dwmc",
"t_subbranch"."jsmc"
FROM "t_account",
"t_manager",
"t_subbranch",
"t_unit",
"t_cz"
WHERE ( "t_account"."khjl_id" = "t_manager"."khjl_id" ) and
( "t_account"."khjh" = "t_subbranch"."jsdm" ) and
( "t_manager"."dwbh" = "t_unit"."dwbh" ) and
( "t_account"."cz" = "t_cz"."czdm" ) and
( ( "t_account"."dqrq" >= :d_start ) AND
( "t_account"."dqrq" <= :d_end ) AND
( "t_unit"."sj" = :s_sj ) )
"t_account", 20万
"t_manager", 2万
"t_subbranch",5千
"t_unit",5千 "t_cz" 100条
这样的速度可以吗?我现在没有真实数据测试!