Re: Unexpected SQL performance behavior

[Charles Wilt <charles.wilt@xxxxxxxxx>]

What does Visual Explain show?

In particular
Under INI Options
Optimization goal *FIRSTIO
Under Environment Information
Interactive Process No
Positioning Options Any
Optimize for N Rows 30
Fetch First N Rows All Rows
Adding
optimize for 60 rows
to the select may help

May help...

Charles


On Tue, Mar 1, 2022 at 8:59 AM Denis Robitaille <
denis_robitaille@xxxxxxxxxxxx> wrote:

> Hello all,
>
> I am currently working on a complex (for me) SQL script. When I run it to
> display the result on the screen, it works fine. When I change it to put
> the result of the SELECT in a file (by inserting the appropriate INSERT
> INTO... before the SELECT), it takes more that 10 times longer to execute!!
>
> I am working with a small subset of data and the resulting data set is
> just 51 rows.
>
> Any help on understanding this behavior and on how to avoid it is very
> appreciated.
>
> [cid:image001.png@01D82D5A.F658C930]<http://www.cascades.com/fr>
> Denis Robitaille
> Analyste TI
> CASCADES CANADA ULC
> 412 Boul. Marie-Victorin
> Kingsey Falls (QC) Canada  J0A 1B0
> Tél. : 819 363 6100   Poste : 52130
> Cell. : 819 352 9362
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com