index rebuilding...

From: Glen A Stromquist <glen_stromquist_at_no.spam.yahoo.com>
Date: Wed, 29 Jan 2003 20:40:52 GMT
Message-ID: <o%WZ9.61302$c41.1415158@news2.telusplanet.net>

I want to rebuild the indexes on one of our databases, this particular one has some indexes that have what seems to be some really out-to-lunch storage settings, so I want to set new ones in the rebuild.

I want to write a dynamic script to build the rebuild statement with the optimum storage params for each index, either that or find a script that does such a thing, but my initial searches have proven fruitless for what I want to do. Which dd tables/views should I be hitting for this query to build the rebuild statement?

suggestions?

TIA Received on Wed Jan 29 2003 - 14:40:52 CST