How to enable fast searches in SQL Server Table with Large Data

Question

HI I have table in database and bind some control from this Tablemy table have many rows about 9000 rows I want searching and reading data from this table be fast that my webpage can show data faster than before how I can do itBest regards

Mudassar · Accepted Answer

1 Do Indexing on the columns you need to search For that you will have to spend some time learning indexes dont expect to be fast or readily available as in this no one can helpOverview of SQL Server 20052008 Table Indexing Part2 Make use of Full Text Search fo searching

How to enable fast searches in SQL Server Table with Large Data

Overview of SQL Server 2005/2008 Table Indexing (Part-

Company

Explore

Follow us

Contact Us