Re: Full logical logs . HELP!!!

ramp <willypo@svalero.es> wrote: >Hello: >I get full my logical logs when i declare select cursors (the cursors >have sum(..), group , ...) , i don=B4t understand why they get full >because are select not update,insert or delete . > > >Thanks in advance , please answer i you can to : > yunitec@sinix.net >-- = > >Un saludo civil > >http://www.svalero.es/~willypo Select statements with "group by"'s sometimes require temp tables to be used. The inserts into these implicit temp tables are logged in the 5.x Engine. If the temp table can be explicitly created, then the "with no log" option can be used. ___________________________________________________________ Jay Aymond United Life & Annuity Insurance Company Email: jay@ulife.com