You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
1.1 KiB
20 lines
1.1 KiB
-- 加速基于产品名称的查询。
|
|
CREATE INDEX idx_product_name ON products (product_name);
|
|
-- 加速基于客户姓名的查询
|
|
CREATE INDEX idx_customer_name ON customers (customer_name);
|
|
-- 加速基于销售人员姓名的查询
|
|
CREATE INDEX idx_salesperson_name ON sales_people (saleperson_name);
|
|
-- 加速基于订单日期的查询
|
|
CREATE INDEX idx_order_date ON sales_orders (order_date);
|
|
-- 加速基于退货日期的查询
|
|
CREATE INDEX idx_return_date ON returns (return_date);
|
|
-- 加速基于订单ID和产品ID的联合查询
|
|
CREATE INDEX idx_order_product ON order_details (order_id, product_id);
|
|
-- 加速基于客户ID和订单日期的联合查询
|
|
CREATE INDEX idx_customer_order_date ON sales_orders (customer_id, order_date);
|
|
-- 加速基于销售人员ID和订单日期的联合查询
|
|
CREATE INDEX idx_salesperson_order_date ON sales_orders (salesperson_id, order_date);
|
|
-- 加速基于供应商公司名称的查询
|
|
CREATE INDEX idx_supplier_company_name ON suppliers (company_name);
|
|
-- 加速基于仓库位置和产品ID的联合查询
|
|
CREATE INDEX idx_warehouse_product ON product_warehouses (warehouse_id, product_id); |