使sql查询变化快速变化 [英] Make sql query vary vary fast

问题描述

请告诉我



大约有2个缺少行，每行包含15列意味着我的sql server 2012快速版数据库中有2个缺少记录/>


现在我想让我的所有选择查询变化很快就像



select * from tblxxx其中title = 'xxx和xyz'



如何让这种类型的查询变化不定



请告诉我简短而清楚地说明如何做到这一点。

Please tell me

There is about 2 lacks rows and each row contain 15 columns means there are 2 lacks record in my sql server 2012 express edition database

now I want to make my all select queries vary vary fast like

select * from tblxxx where title='xxx and xyz'

how to make this type of query vary fase

please tell me with brief and very clearly and examples how to do it.

推荐答案

关注这些链接...希望它有所帮助

优化SQL Server数据访问的10个步骤：第一部分（使用索引） [ ^ ]



[ ^ ]



一切顺利.....

Follow These links...Hope it helps
Top 10 steps to optimize data access in SQL Server: Part I (use indexing)[^]

Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]

All the best.....

这篇关于使sql查询变化快速变化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！