Re: Set Explain

CSC CIS wrote: > > Try creating a function which is called from all the programs at startup = > and which checks the value of an environment variable and turns SET = > EXPLAIN ON. The programmer should turn on the variable during testing, = > and the production environment should have this turned off. We do this = > here and it works. > > Sujit Pal Depends on how "set explain" is used. If its always turned on just at the beginning of the program this system might work. If the set explain is buried in the code to check out just one or a few particular SQL statements, then it's not so appropriate. I stand by my first solution, but just to be fair (since I'd probably get caught by my own solution sometime) here's another: Teach the programmers to use 'sed' or 'grep'. Douglas Wilson ** The opinions expressed here are not always the best... but not the worst either **