Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
> 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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement