hello *,
i am constructing a rather longish join where i want to select distinct
rows only. however, i know that the join-rows i collect are distinct
within the first two columns (it's a primary key of one of the join
partners). many more columns are selected.
question: can the optimizer tell how much of the query result to test
for distinctness ? can i help by providing the information to the
optimizer ?
thanks for any advice,
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
