sp_configure

optimize temp table resolution

Summary information
Default value	0
Range of values	0, 1
Status	Dynamic
Display level	Intermediate
Required role	System administrator
Configuration groups	Query Tuning

When enabled, allows Adaptive Server to reuse the cached statement plan for multiple sessions, even if the statement involves temporary tables. Adaptive Server reuses the cache statement plan if the schema for the recreated temporary tables is the same as the previous temporary tables.

Cumulative Dumps

With the introduction of cumulative dumps, you can now configure these settings using sp_configure:

You can now use the sp_configure system procedure to configure Adaptive Server to enable concurrent transaction dumps and cumulative database dumps by setting the enable concurrent dump tran parameter 1:
```
sp_configure 'enable concurrent dump tran', 1
```
You cannot, however, have concurrent dump cumulative and dump database, since dump cumulative needs dump database to finish, because dump cumulative copies all those pages that changed once dump database is finished.
Record cumulative dump commands in the dump history file by enabling the enable dump history configuration parameter:
```
sp_configure 'enable dump history', 1
```

Gathering Index Attributes Using Hash-Based Statistics

The utility statistics hashing option for sp_configure is available in Adaptive Server 15.7 SP100.

utility statistics hashing enables the gathering of index attributes using hash-based statistics when creating an index. The options are:

on – index attributes are gathered using hash-based statistics.
off – the sort-based algorithm from versions of Adaptive Server earlier than 15.7 ESD #2 is used.
new – hashing is gathered for minor attributed columns that have not had statistics previously gathered.
default – same as off.

The values of create index hashing option take precedence over utility statistics hashing. If the clauses hashing, new hashing, or no_hashing have not been specified in the create index command, the value of utility statistics hashing is used.