Optimize for "N" rows

greenspun.com : LUSENET : DBAzine : One Thread

1. Will use of "OPTIMIZE FOR 'N' ROWS" actually increase the performance of the SQL if I need only "N" rows from the total number of rows fetched by the SQL ?

2. "OPTIMIZE FOR 'N' ROWS" , Will it fetch back only "N" rows in the table spaces or bring all the rows (but do background DB2 processing only "N" rows).

Kindly explain.

-- King Sundararaj (king@eth.net), October 03, 2002

Moderation questions? read the FAQ