Posted by paul on 06/28/05 16:31

Hi, i have a table like this
CREATE TABLE dbo.test
(
num int NOT NULL,
ename char(80),
eadress char(200),
archived char(1)
PRIMARY KEY CLUSTERED (num)
)

create index i_archived on dbo.test(archived)

the are 500000 rows in this table, and the archived field contain 15000 'Y'
and 485000 'N'


When i issue a select * from test where archived='Y',
the path choosed is the index scan clustered and not the index i_archived

the stats are updated every day.

did i miss something ?


thx

[Back to original message]