General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
> I'ld argue strongly for every information to be parseable from the logfile as well as
> the chance to access it from an array structure.
I see you didn't get my suggestion fully, ASHOWPLAN would create an array on demand, if you specify cSQL. As it's optional, ASHOWPLAN should also be capable to work for each following select, like sys(3054) does. It may then append to the array. Let there be some header array row for each select, to be able to sort out, which rows are for which SQL.
A redirection to a log file instead of an array output, like sys(3092) does, would of course also be nice, perhaps in some sdf or tab delimited format, that represents the same structure as the array.
Bye, Olaf.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only