How to make table fast to retrieve data in SQL Server?

You can fast your retrieval through Indexing. First understand the concept of Indexing with simple example.

Reading from a table that has no index is similar to finding a word in a book by examining every single page in that book.

Having an index in the front of the book will allow the reader finds their target faster.

The same applies to the SQL Server tables; having an index on the table, will speed up the data retrieval process, providing the client with the requested data in shorter time, of course, if the index is designed properly.

Create an Index using the below query and you can check the execution plan after applying Indexing.

CREATE NONCLUSTERED INDEX IX_YourTable_ID ON [YourTable] (ID)

you can create a non cluster index for faster search operation.

 

 

CREATE [NONCLUSTERED] INDEX index_name ON table_name(column_list);