Usage Note 38393: NOMISS index support option removed from SAS® Scalable Performance Data Server
SAS® Scalable Performance Data Server allows you to create NOMISS indexes, but the server will never use a NOMISS index for any WHERE clause evaluation, join, or sort. The purpose of the the NOMISS option is to reduce the size of the index for tables that contain a large number of missing values. This, however, is not needed for SAS Scalable Performance Data Server indexes because bitmap indexes are used.
Starting with SAS Scalable Performance Data Server 4.4TSM10 and 4.5 TSM0, if the NOMISS=YES option is used, the option will be ignored and the following message written to the SAS log:
SPDS_WARNING: NOMISS option is ignored for SPD Indexes
SPDS_NOTE: Simple index X has been defined
Operating System and Release Information
| SPDS | Scalable Performance Data Server | Microsoft Windows 2000 Advanced Server | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| Microsoft Windows 2000 Datacenter Server | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| Microsoft Windows 2000 Server | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| Microsoft Windows 2000 Professional | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| Microsoft Windows Server 2003 Standard Edition | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| Microsoft Windows XP Professional | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| 64-bit Enabled AIX | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| 64-bit Enabled HP-UX | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| 64-bit Enabled Solaris | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| HP-UX IPF | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| Solaris for x64 | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
| Tru64 UNIX | 4.4 TSM0 | 4.4 TSM10 | | 9.1 TS1M3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Date Modified: | 2010-03-09 18:58:35 |
| Date Created: | 2010-01-13 18:03:08 |
