Index Rebuild Command for particular table indexes

rajeev.babu

rajeev.babu

Member
Hi,

Please provide me the command for Index Redbuild for a particular table:-

1)A table contains 5 indexes and I want to do index rebuild for all the 5 indexes.
2)A table contains 5 indexes and I want to do index rebuild for only one index.

Thanks in Advance.
 
Please provide me with evidence that you have at least attempted to check the documentation and found it inadequate in some way.
 
Sorry for a wrong question. I actually meant...if I want to do the index rebuild for a table with 100 index.

protuil dbname -C idxbuild will ask for the table name and then ask for the index name. I dont want to give 100 index names there. Is there any other method or command for index rebuilding without specifying all the index name
 
It's always good to ask the question that you really want to have an answer for. Asking the wrong question almost always results in getting the wrong answer ;)

Since it is apparent that you do not have access to the documentation I'll quote the relevant bit:

Code: 
proutil db-name -C idxbuild [ all |table [owner-name.]table-name | area area-name |     schema schema-owner | activeindexes | inactiveindexes]  [ -thread n ] [ -threadnum n ] [ -T dir-name | -SS sort-file-directory-specification ] [ -TB blocksize ] [ -TM n ] [ -B n ] [ -SG n ] [ -pfactor n ]

If, for example, you wanted to rebuild all of the indexes for the Customer table in the sports2000 db you could use:

proutil sports2000 -C idxbuild table Customer

If you cannot get your employer to install the the e-docs on your PC you might want to ask for a firewall exception allowing you to get to progress.com so that you can access the online documentation.
 
You must log in or register to reply here.
Back
Top