Hi Have been reading in some blogs that having a WHERE clause in the SELECT queries is helpful. I just wanted to know is this true? For e.g I have a table With following columns STOREID char(5) DEPTID int With both the above acting as a COMPOSITE Key. Most if not all of my selects and Joins with the table above result in only one of the 2 columns being used , as a result giving me Clustered Index Scan. Let me presume here DEPTID is used as a part of the JOIN With another table. If i simply add a WHERE condition to above, say WHERE STOREID >'00000' It does result in giving me a clustered index seek. But does this really help ,as my Query Plan shows me the same results with Clustered Index Scan and also with Clustered Index Seek. I know this is not quite a 2005 issue, but wonder is anyone can help.