具有3组和1个功能的SQl查询 [英] SQl Query with 3 group by and one function

问题描述

我正在处理一个具有天赋的查询，具有3个分组和一个功能.查询时间超过15分钟，最终用户等不了那么长的时间
我已经做了几件事，包括:
(1)Performance Tunning，
(2)重写索引(群集和非群集)

I am working on one query with was gifted to me to work on has 3 group by and one function. THis query takse more than 15 minutes and end user can''t wait that long
I already have done several thing includes:
(1) Performance Tunning,
(2) Rewrite Index(Clustered and nonclustered)

推荐答案

使用Sqlprofiler，数据库优化顾问并使用唯一索引

是提高性能的更好方法.

Use Sqlprofiler , Database tuning Advisor and use Unique index

is better way to increase performance.

这篇关于具有3组和1个功能的SQl查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！