Fox wrote: > > When i ask for just 100 rows from big table is the database > serwer produce > whole rows or just the asked one? > It depends. For single table selects only the first <rowno> rows are produced. But within joins the rowno predicate only limits the last table access. Every temporary join results includes the whole result rows.
Additionally you should know that if a rowno predicate and an order clause are specified, only the first n result lines are searched and sorted. The result usually differs from that which would have been obtained if a rowno predicate had not been used and if the first n result rows had been considered. HTH. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
