Re: first 'n' rows

From: Esther <estherNOesSPAM@ts.es.invalid> > >I would like to know how can I use the "FIRST_ROWS" optimizer directive >and the "SELECT FIRST 'n' ROWS" directive. I don't know the syntax. >Thank you for your help. Right, there seems to be some confusion here: the FIRST_ROWS directive has nothing to do with SELECT FIRST N ROWS. The directive is there to tell the engine to get first rows back to the client as quickly as possible, even if the total query takes longer. Whether you are using SELECT FIRST N or not. To use the SELECT, simply say: SELECT FIRST 10 * FROM mytable; HTH. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com