This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:sql:statements:update_indexes:home [2011/06/29 23:03] admin |
dev:sql:statements:update_indexes:home [2012/10/26 15:00] (current) |
||
|---|---|---|---|
| Line 40: | Line 40: | ||
| ==== WIth Options ==== | ==== WIth Options ==== | ||
| - | === MAX_THREADS === | + | === MAX_THREADS - Setting the number of processors used for indexing === |
| MAX_THREADS=thread_count allows the setting of the maximum number of processors to be used during the update index process. | MAX_THREADS=thread_count allows the setting of the maximum number of processors to be used during the update index process. | ||
| Line 50: | Line 50: | ||
| UPDATE INDEXES WITH LOG=odxlogs; | UPDATE INDEXES WITH LOG=odxlogs; | ||
| - | UPDATE INDEXES WITH LOG=c:\mydatabase/log | + | UPDATE INDEXES WITH LOG=c:\mydatabase\log |
| === BUF - Setting the amount of indexing memory === | === BUF - Setting the amount of indexing memory === | ||
| Line 66: | Line 66: | ||
| > update indexes with log=odxlogs; | > update indexes with log=odxlogs; | ||
| > setenv oa_max_rows | > setenv oa_max_rows | ||
| - | > update indexes with log=odxlogs; | ||
| > exit | > exit | ||
| os> | os> | ||