What is the method of rebuilding indexes in 9.4? Could you possible
include some systax?

Thanks in advance

There are more than this option i use:

ALTER FRAGMENT ON INDEX the_index_name INIT IN dbspace_name;

Other people prefer the DROP/CREATE procedure to rebuild, but that can
get nasty when you constraints etc.

Thanks for your response. Do I do this for every index? There is three
indexes within the same table. Also how do I go about updateing
statistics on that table?

Yes, you have to do this for every index you want to rebuild.
Consider, that you will have a downtime for the table on which the index
is. (The Rebuild places an exclusive table lock on that table.)
And you need enough spaces in your temp dbspace.
So, to find out how much time and temp space you need, you should test
the index rebuild on your test system, which should match as much as
possible (data volume etc.) the production system.

To get the statistics of a table, i use:

UPDATE STATISTICS MEDIUM FOR TABLE table_name;

Hendrick wrote:
> Thanks for your response. Do I do this for every index? There is three
> indexes within the same table. Also how do I go about updateing
> statistics on that table?
>

See the Performance Guide manual and John Miller III's paper about the
latest optimizations inside later IDS versions and how to take advantage of
them to compute statistics faster:

http://www.ibm.com/developerworks/db...203miller.html

Or just get my dostats utility in the package utils2_ak available from the
IIUG Software Repository (new release dated 3/27/2006 will be posted
shortly, I uploaded it last week and Peter's working on it).

Art S. Kagel