Date:28.08.2016, 06:13 Such constructs may prevent you from benefiting fully from the capabilities of Adaptive Server 15.0. With Adaptive Server ESD #2 or later, you can enable two trace flags: Trace flag15307 nullifies the effect of any set forceplan statements during query plan compilation. Enable literal autoparam applies only when the statement cache is enabled. With literal autoparameterization enabled, caching is extended to almost-identical queries that differ only in a constant value. For example, these two queries are not considered identical: select CustName from Customers where CustID 123 select CustName from Customers where CustID 456 However, they are likely to generate the same query. Literal parameterization allows Adaptive Server to recognize queries that are identical except for differeing in literal values in the where clause. In addition to performance benefits, literal parameterization leads to significant space reduction when the metrics and statements are stored in the cache. Enabling literal autoparameterization has the effect that the statement cache factors out the constant value in the where clause and caches a plan for all queries that look like this: select CustName from Customers where CustID integer-constant Obsolete optimization commands in Adaptive Server 15.0 Various optimization-related settings from 12.x are no longer relevant in Adaptive Server 15.0. You may also create multiple temporary databases and assign them to specific users. To check the tempdb space used by a single session, use: select pssinfo(spid0 tempdb_pages Enable the statement cache and literal autoparameterization settings while running large numbers of identical or similar client-generated SQL queries in Adaptive Serer or later.
On May 22, 1967, Hughes died from complications after abdominal surgery related to prostate cancer at the age of 65. His ashes are interred beneath a floor medallion in the middle of the foyer leading to the auditorium named for him within the Arthur Schomberg Center for Research in Black Culture in Harlem.