How fast are 1 Click DB Searches?
Out of the box standard 1 Click DB only retrieves as many records from a query as is needed to display the current page. This makes it very efficient compared to most alternatives for display of very large recordsets (with millions of records) Indexing is different; it helps determine how long SQL Server will take to figure out what subset of your millions of records meet your search criteria. SQL Server indexes work like a alphabetical list. So if you have an indexed Address field and are looking for all records that start with “123” or exactly match “123 Main St”, then SQL Server can just do an alphabetic lookup on the index to find matching records and will be very fast. However, if you want to return all records that contain the word “Main” in the Address field then the index is useless because even though you have an alphabetic list, the db still has to check every single record to see if “Main” is found anywhere in it. The alphabetic list is not helpful in this case because you a
