Results 1 to 2 of 2

Thread: set explain on

  1. #1
    Join Date
    Aug 2002
    Location
    INDIA
    Posts
    24

    Unanswered: set explain on

    Does setting of 'SET EXPLAIN ON' in 4GL / EC drastically affect the performance?

    One of our programs with 'SET EXPLAIN ON' runs for 30 mins,
    with 'SET EXPLAIN OFF' runs for just 20 secs.

    Thanks & regards,
    Ramesh

  2. #2
    Join Date
    Mar 2002
    Posts
    112

    re

    It effects ...
    explain on for diagnostics the queries at a time not all the times

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •