Prueba con
SELECT * FROM fmnnus
fetch first 20 rows only
"Informatica" <[EMAIL PROTECTED]>@QUIJOTE.COMBIOS.ES con fecha
06/06/2003 09:09:37
Por favor, responda a [EMAIL PROTECTED]
Tram�s per: [EMAIL PROTECTED]
Destinataris: "Forum.Help400" <[EMAIL PROTECTED]>
C�pia:
Classificat: |----------------|
| ( ) Important |
| ( ) urgent |
| ( ) hist�ric |
| ( ) temporal |
| ( ) bretolada |
| ( ) particular |
|----------------|
Assumpte: Re: Limitar resultados de un Select
----- Original Message -----
From: "alex martinez" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 05, 2003 6:23 PM
Subject: Re: Limitar resultados de un Select
> SELECT * FROM TABLITA OPTIMIZE FOR 10 ROWS
>
Pues no se, parece que no funciona. Por lo que he leido, en el manual, esta
clausula le dice al GBBDD que se pretenden aprovechar del resultado solo
las
10 primeras filas, pero no "truncando" el resultado. Parece mas bien un
tema
de rendimiento. �hay que controlar luego el resultado por programa?
Del manual de SQL:
OPTIMIZE integer ROWS
The optimize-clause tells the database manager to assume that the program
does
not intend to retrieve more than integer rows from the result table.
Without
this
clause, or with the keyword ALL, the database manager assumes that all rows
of
the result table are to be retrieved, and it optimizes accordingly.
Optimizing for
integer rows, or at a minimum, the number of rows that are fetched, could
improve
performance. The clause does not change the result table or the order in
which the
rows are fetched. Any number of rows can be fetched, but performance can
possibly degrade after integer fetches. The clause can appear either before
or after
an accompanying update-clause or read-only-clause.
optimize-clause
_____________________________________________________
Forum.HELP400 es un servicio m�s de NEWS/400.
� Publicaciones Help400, S.L. - Todos los derechos reservados
http://www.help400.es
_____________________________________________________
Para darte de baja, env�a el mensaje resultante de pulsar
mailto:[EMAIL PROTECTED]
_____________________________________________________
Forum.HELP400 es un servicio m�s de NEWS/400.
� Publicaciones Help400, S.L. - Todos los derechos reservados
http://www.help400.es
_____________________________________________________
Para darte de baja, env�a el mensaje resultante de pulsar
mailto:[EMAIL PROTECTED]
