FREE Registration is required
Overview:
In a NESUG 2007 paper with Shuguang Zhang, The author demonstrated a compressed index (termed "Condensed index" in that paper) which provided significant performance gains (about 33% elapsed time and cpu time) in retrieving subsets from sorted datasets in which each level of the sort variables(s) has many observations, and the sort variable was used as the selection criterion. This paper extends the compressed index in two ways: replication of a SAS composite index, and further performance gains (up to 50%) by selectively replacing direct access (i.e. POINT=) techniques with sequential access (FIRSTOBS and LASTOBS). This paper demonstrates, with sample DATA steps, how to create and use a compressed index, and compares its performance to SAS indices, and to the previous results.
(Is this item miscategorized? Does it need more tags? Let us know.)
| Format: | Size: | 289 KB | |
| Date: | Feb 2009 | ||
| Pages: | 9 |
Top results from Application Development
» View all Application Development listings
Top results from Knowledge and Data Management
White Papers, Webcasts, and Resources
- Business Continuity Planning - IT Survival Guide CA XOsoftLearn how to begin the process of developing an effective business continuity plan designed to minimize the impact of disasters and reduce risk.
- Techical Whitepaper: Configuring Deduplication for High Performance Dell EqualLogicReduce disk storage requirements--while enabling higher performance--by learning to configure de-duplication for your primary storage policy copies.
- Whitepaper: Fast, Reliable Data protection from Dell and CommVault Dell EqualLogicOvercome the challenges of increasing data growth with a disk-based backup and recovery solution offering integrated de-duplication technology.
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
Featured Training Courses
- Implementing and Administering Windows 7 in the Enterprise
- CCNA Boot Camp v2.0
- VMware vSphere: Install, Configure, Manage [V4]
- Certified Ethical Hacker
- Management and Leadership Skills
- Browse all Training Courses
SmartPlanet
- Thought-provoking progressive ideas on diverse topics that intersect with technology, business, and life, and matter to the world at large. Visit SmartPlanet
- More from IBM
- How to Drive Better Business Outcomes with Exceptional Web Experiences Download the eBook
- Driving Business Agility through SOA Connectivity & Integration Read the White Paper from IBM
- Linking Decisions and Information for Organizational Performance Read the Tom Davenport study



