----- 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]
