As the first step in the decommissioning of the site has been converted to read-only mode.

Here are some tips for How to share your SAS knowledge with your professional network.

Tips:Increasing the Size of an Index Page

From sasCommunity
Jump to: navigation, search

Did you know that: you can increase the page size of SAS indexes when they are first created by using the IBUFSIZE option?

The default IBUFSIZE is 4096 bytes. You can change that setting by specifying IBUFSIZE=xxxxx. The author of a recent book on SAS indexes recommends setting IBUFSIZE=32767 (the maximum) on all SAS platforms except for z/OS, where he recommends setting it to 27648. (However, he presents the caution that this has not been rigorously tested on SAS data sets of varying sizes on _ALL_ of the operating systems that SAS is run on. So, your mileage may vary).

Submitted by Michael A. Raithel, The man who wrote the book on performance.. Contact me at my Discussion Page.

....see also