Hi,
I need some help with indexes. I've created a table and index.
create table test(
id serial,
name varchar(20),
primary key(id)
)
create index indexName on test(name)
update statistics test
and when I tried explain select name from test where name = 'blah'.
it gave me 'table scan', while I'm expecting an index lookup.
What could be the cause ?
And also I'm using 7.4, what database parameters are important for optimization ?
Thanks in advance,
Jason.
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
