You can create multiple indexes on the same table, but you must use a separate CREATE INDEX statement for each index that you want to create.
- SAS® Certification Prep Guide
- from SAS® Certification Prep Guide: Advanced Programming for SAS®9, Third Edition
- Publisher: SAS Institute
- Released: July 2011
Ask Sam or another architect about multiple indexes. If you have two indices, are you essentially storing two instances of the same table, presorted according to the corresponding index?
Share this highlighthttp://www.safaribooksonline.com/a/sas-certification-prep/4348410/