如何维护数据优化

本文介绍了如何维护数据优化的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

如何维护数据优化. 目前，我在获取数据时面临很多问题，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.

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