hi!
i created a table with 2 FIXED values as primary key and a column
VARCHAR(512).
EXPLAIN tells me that "select * " where that varchar is 'foo' results in
a table scan (!) although i created an index on that column. "select
count(*)" with the same condition is a "EQUAL CONDITION FOR INDEXED
COLUMN", resulting in a much lower cost value.
is the explain statement not telling the truth? shouldnt it use the same
strategy when selecting * ?
this is kernel 7.3.0.20 via JDBC...
TIA,
Raimund
--
Raimund Jacob
\|/ ____ \|/
Pinuts Media+Science GmbH "@'/ ,. \`@"
Potsdamer Str. 96 /_| \__/ |_\
D-10785 Berlin \__U_/
http://www.pinuts.de/ voice: +49 30 590090313 fax: +49 30 590090390
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
