I currently have a SQL Server 2005 database whose table contains receipt information. Currently the table contains several million records. A basic select query for a specific row takes a bit of time. There is an index on the table.
My question is this, is there anything that can be done, in general to improve the performance of this table and similar systems in SQL Server 2005. Anything regarding specific ways to establish an index, database configuration changes, etc.
I understand this is a bit vague but I am looking for one or more ideas that I can apply to the database in general.
Thanks for the help!