如何维护数据优化 [英] How to mainatin data optimization

问题描述

如何维护数据优化.
目前，我在获取数据时面临很多问题，bcoz的一个表包含350万个记录.当我对此表执行查询时，发生连接超时.如何保持对我的帮助.

问候，
Purnananda Behera

Hi,

How to maintain data optimization.
Currently i am facing lot of problem to fetch data, bcoz one table consist of 35 lakh records. when i executing query against this table then connection time out is occurring. how to maintain help me.

Regards,
Purnananda Behera

推荐答案

使用SQL事件探查器查看问题出在哪里，它将为您提供所需的提示和索引.

Use the SQL Profiler and see where your problem is and it will give you hints and indexes needed.

http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/RelDWMgmt.doc [

http://sqlcat.com/sqlcat/b/top10lists/archive/2008/02/06/top-10-best-practices-for-building-a-large-scale-relational-data-warehouse.aspx[^]
http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/RelDWMgmt.doc[^]

这篇关于如何维护数据优化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！