The optimizer has determined that the cost of the bookmark lookup (to get the recnum and quantity) outway the benefit of the non-clustered index seek. If you are having a performance problem with this query, you could consider a covering index.When I do this...create table gainandloss (recnum int,quantity int,trade_date datetime )create index idx_blah on gainandloss(trade_date)goselect recnum,quantityfrom gainandloss where trade_date >='06/01/2002' and trade_date <='06/30/2002'go
...it does use the index and bookmark lookup. Granted, I have no data, so the statistics are worthless.create index idx_cover on gainandloss(trade_date,recnum,quantity)goselect recnum,quantityfrom gainandloss where trade_date >='06/01/2002' and trade_date <='06/30/2002'go
...That should cover the query though...Jay White{0} 
NonClustered Index
Posted - 2002-08-06 : 13:22:32
