Sql Server, Query Optimization.
index or statistics — SELECT * FROM <YourTable> WITH (FORCESEEK (<index_name>)) WHERE <YourCondition>; Update statistics manually — While SQL Server automatically updates statistics, you can also update them manually using the following command — UPDATE STATISTICS <table_or_index_name>; UPDATE