Kbase P106852: How to perform a binary dump using a specific index
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to perform a binary dump using a specific index ?
GOAL:
How to perform a binary dump using a index other than the primary index ?
GOAL:
How to specify an index on a binary dump ?
GOAL:
What is the default index used on a binary dump ?
FIX:
proutil <database name> -C dump <table name> <target directory> -index <index number>
By default the primary index will be used to dump the data, which might not be the best option since primary index key are usually not stored in contiguous database blocks resulting in slower data retrieval and poorer performance. A good option will be:
An index that helps store data contiguously in the source database ( binary dump will be faster)
An index that is used to read large amounts of data in the target database (reading of data on the target database will be faster
The index number of the smallest index
Word indexes CAN NOT be used to search the content of a table