Index seek and Index scan
-
Hi, If i am writing simple select query like Declare @parentInventoryId int SELECT InventoryID FROM Inventory_Profile WHERE ParentInventoryID=@parentInventoryId In query execution plan i am getting index scan, but i need index seek can anybody tell how to change the query to get index seek in my query execution plan
-
Hi, If i am writing simple select query like Declare @parentInventoryId int SELECT InventoryID FROM Inventory_Profile WHERE ParentInventoryID=@parentInventoryId In query execution plan i am getting index scan, but i need index seek can anybody tell how to change the query to get index seek in my query execution plan
On what column do you get an indexscan ? did you make indexes ? on what columns ? did you make a covering index ? by adding the requested data and the filtering data in one index, sql does not have to go to the table itself, just the index is enough how many rows of data are there in this table ? SQL server ignores indexes when there are few rows of data My second computer is your linux box.