SQL Server数据库性能 [英] Sql server DB Performence
问题描述
我正在使用SQL SERVER 2005数据库.
在子表中有3个记录核心,而在主表中有2个10万记录
所以当我访问数据或运行查询时,要花费很多时间来获取数据...所以请给我任何建议,以便我可以更快地获取数据....
谢谢
Manish Khandelwal
>
感谢您的发帖!我建议将您的问题发布到位于以下位置的"SQL Server数据库"中: http: //social.msdn.microsoft.com/Forums/zh-CN/sqldatabaseengine/threads
祝您度过愉快的一天!
谢谢!
I am using SQL SERVER 2005 Database.
In the child table there are more then 3 cores of records and in the master tables there are more then 2 lakhs record
so when i accessced the data or run the query it takes lots of time to fetch data ...so plz suggest me any idea so that i can fetch data faster....
Thanks
Manish Khandelwal
Hello,
Thank you for your post! I would suggest posting your question in the 'SQL Server Database' located here: http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/threads
Have a great day!
Thanks!
这篇关于SQL Server数据库性能的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!