The SQLSC_PLAN (SCP) table contains a row for each combination of plan options that can affect a query's generated executable object from queries in the Cache. For a query to match in the Cache, these plan options must be identical. Other plan options, however, because they do not affect the generated plan use the current plan, and therefore are not required to match.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
SCP_ID |
INTEGER |
No |
Unique ID |
|
Plan Options follow: |
|
|
For descriptions, see the CA Datacom/DB SQL User Guide |
|
CHK_PLAN |
CHAR(1) |
No |
Plan execute privilege |
|
CHK_WHO_BINDER |
CHAR(1) |
No |
Access rights of binder or executor |
|
CHK_WHEN_BIND |
CHAR(1) |
No |
Table-level privileges checked at bind or runtime |
|
PLAN_HAS_DYN_STMT |
CHAR(1) |
No |
Dynamic statement in plan |
|
CURSOR_BEHAVIOR |
INTEGER |
No |
Commit and rollback behaviour |
|
SQLMODE |
CHAR(8) |
No |
Mode to process the program |
|
ISOLATION |
CHAR(1) |
No |
Isolation level |
|
OPTMODE |
CHAR(1) |
No |
Join optimization mode |
|
TIMEFORM |
CHAR(3) |
No |
Time output format |
|
DATEFORM |
CHAR(3) |
No |
Date output format |
|
DECPOINT |
CHAR(1) |
No |
Period or Comma to be decimal point indicator |
|
STRDELIM |
CHAR(1) |
No |
String delimiter apostrophe or quotation mark |
|
Copyright © 2014 CA.
All rights reserved.
|
|