Nubbin question :(

[WangKhar]

create table guidtest(a int primary key clustered, b uniqueidentifier,
c varchar(200))

insert into guidtest values (1, newid(), 'ashakhfoagfoahfafdsa')
insert into guidtest values (45, newid(), 'EWRYEYYTURJ')
insert into guidtest values (231, newid(), 'WYEW')
insert into guidtest values (73573, newid(),
'ashakhgs\YEW5Yfoagfoahfafdsa')
insert into guidtest values (463784, newid(),
'ashakhfoagDGHHDDfoahfafdsa')
insert into guidtest values (416571371, newid(),
'ashakXHSDFSGRSRhfoagfoahfafdsa')
select * from guidtest where b =
'9EE19242-5C78-4520-9F0A-365A42237BB0'

select * from guidtest where c = 'ashakhfoagDGHHDDfoahfafdsa'

Query plans for the 2 queries show pk scan.

My sarg isn't on the pk. Am I just being a nub?

[lucjanc]

Hello, primary key scan, is another way of saying clustered index scan, or
simply clustered table scan. Since you have clustered index there, table
scan = clustered index scan. Saying all that , whether optimazer will pick
index or scan also depends also on size of the table. In your case table is
small , fits on one page, 2 pages when has index. So scan of the table I/O
costs is 1 page, when using index 2 pages. Better to scan in this particular
case :)). But, in general it all depends on cost analysis that are done by
optimazer.

cheers,

Lucjan

"WangKhar" <Wa******@yahoo.com> wrote in message
news:bb**************************@posting.google.c om...

create table guidtest(a int primary key clustered, b uniqueidentifier,
c varchar(200))

insert into guidtest values (1, newid(), 'ashakhfoagfoahfafdsa')
insert into guidtest values (45, newid(), 'EWRYEYYTURJ')
insert into guidtest values (231, newid(), 'WYEW')
insert into guidtest values (73573, newid(),
'ashakhgs\YEW5Yfoagfoahfafdsa')
insert into guidtest values (463784, newid(),
'ashakhfoagDGHHDDfoahfafdsa')
insert into guidtest values (416571371, newid(),
'ashakXHSDFSGRSRhfoagfoahfafdsa')
select * from guidtest where b =
'9EE19242-5C78-4520-9F0A-365A42237BB0'

select * from guidtest where c = 'ashakhfoagDGHHDDfoahfafdsa'

Query plans for the 2 queries show pk scan.

My sarg isn't on the pk. Am I just being a nub?