"Expalin" explaination needed

Database
Enthusiast

"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...
1 REPLY
Enthusiast

Re: "Expalin" explaination needed

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.