一条非常长的查询语句:
select username,tel,address,dealdate,orderitem.pname,orderitem.number from orders,orderitem,user where orderitem.oid=orders.oid and orders.userid=user.uid and orderitem.pid=any(select pid from product where product.shopid=?)order by dealdate desc
怎么样才能高性能的统计出查询行数.
select username,tel,address,dealdate,orderitem.pname,orderitem.number from orders,orderitem,user where orderitem.oid=orders.oid and orders.userid=user.uid and orderitem.pid=any(select pid from product where product.shopid=?)order by dealdate desc
怎么样才能高性能的统计出查询行数.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货