Select and Indexes

[aliiiish]

Hi,

Assume we have the following:

CREATE TABLE test1 (
id integer,
content varchar
);

&

CREATE INDEX test1_id_index ON test1 (id);
CREATE INDEX test1_content_index ON test1 (content);

Which Select statement would perfom better?

1) SELECT content FROM test1 WHERE id = constant;
2) SELECT content FROM test1 WHERE id = constant; & content = constant
3) SELECT content & id FROM test1 WHERE id = constant & content = constant

Thanks..Ali

 

[manmaria]

Was it a quiz? or you are not sure?

What are you selecting is not matters as I know and on which condition you are searching is important. I think all 3 will perform very well.