Hi everyone, I'm a newbie in SQL server and have something to ask your opinion. I have a table consist of 600.000 - 800.000 data, put an index on a column (say: CloseDate) and have this query select * from Table1 where CloseDate = 'somedate' and from execution plan I could see that query optimizer didn't use the index, it uses only clustered index scan. so I try to change it to select * from Table1 with (index(ix_table1_closedate)) where CloseDate = 'somedate' and it turns out that the query optimizer uses index seek + bookmark lookup. so can anybody suggest which one is better, I'm quite hintless which one to pick, or is it almost the same since the data is small? and anyway the table is a monthly data table, so it's quite small and the row is quite fix in number (around 600.000 - 800.000). If in this case Index seek won't do any better significantly, then should I avoid it? since using index might slow down insert/update/delete operation. thx a lot guys, sorry for my english.