MS-SQL Server
简单的SQL优化
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区两条SQL语句。感觉有点慢。大家帮忙优化下。。
第一条:
query time:1.7163 秒
------------------------------------------------------------------------------
第二条
query time:0.1272秒
-------------------------------------------
第一条:
SELECT p.products_id
FROM products p, products_to_shops p2s
WHERE (
p.products_model
IN (
'NIB037', 'NAM006', 'DKY004', 'NDE022', 'CSP004SU', 'DPS003', 'TMK030', 'ENB005L', 'VJV04', 'CMN001L'
)
OR p2s.products_new_model
IN (
'NIB037', 'NAM006', 'DKY004', 'NDE022', 'CSP004SU', 'DPS003', 'TMK030', 'ENB005L', 'VJV04', 'CMN001L'
)
)
AND p.products_id = p2s.products_id
AND shops_id = '7'
query time:1.7163 秒
------------------------------------------------------------------------------
第二条
SELECT c.customers_firstname, c.customers_lastname, c.customers_email_address
FROM customers_info ci, customers c
WHERE (
(
ci.customers_info_date_of_last_logon
BETWEEN '2008-07-07 01:49:00'
AND '2008-07-07 21:48:00'
)
OR (
ci.customers_info_date_account_created
BETWEEN '2008-07-07 01:49:00'
AND '2008-07-07 21:48:00'
)
)
AND c.customers_id = ci.customers_info_id
query time:0.1272秒
-------------------------------------------
...全文
