Lars Erik Nes
New Member
Hi
I added a new index to a small table (500 recs) and since the db was online this index was added not-active. I need to active it without stopping the db.
I found this in the knowledgebase
"proutil sports2000 -C idxactivate pub.customer.name useindex cust-num recs 500 refresh 10"
But can i use this since my index contains 2 fields ?
This is the index i added
ADD INDEX "iActiveLineType" ON "servline"
AREA "Index Area"
INDEX-FIELD "sl-linetype" ASCENDING
INDEX-FIELD "sl-active" ASCENDING
What will the correct idxactive statement be ??
//Lars
I added a new index to a small table (500 recs) and since the db was online this index was added not-active. I need to active it without stopping the db.
I found this in the knowledgebase
"proutil sports2000 -C idxactivate pub.customer.name useindex cust-num recs 500 refresh 10"
But can i use this since my index contains 2 fields ?
This is the index i added
ADD INDEX "iActiveLineType" ON "servline"
AREA "Index Area"
INDEX-FIELD "sl-linetype" ASCENDING
INDEX-FIELD "sl-active" ASCENDING
What will the correct idxactive statement be ??
//Lars