|
|
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
Navigation:
[Reply to this message]
|