All Forums Database
rajan-3797 14 posts Joined 01/07
08 Feb 2008
"Expalin" explaination needed

Hi,i have trouble in understanding the different explain plan messages like the one below 1) We do a single-AMP ABORT test from DBC.DBase by way of the unique primary index. what does the above plan means....any idea where to look up for details about the explain plans and their messages.thanks in advance...

Jim Chapman 449 posts Joined 09/04
08 Feb 2008

Abort tests are typically generated to validate the request against some required precondition. For instance, a CREATE USER statement must fail if the name already exists. Therefore a single-AMP abort test would be generated to query DBC.DBASE and abort the request if a row is found with the same DatabaseName value.

You must sign in to leave a comment.