Usually re-indexing a table is seldom required in Cache, but still some issues may occur, either by a program error or by some manual fault, when a re-indexing operation becomes necessary. We will enumerate the steps required to carry-out this operation at the lower levels.
Open Terminal from the Cache cube.
Provide username/password to login.
You will see youself stayed in "USER" namespace.
Type: zn "vouch"
VOUCH>set result = ##class(SQLUSER.MYTABLE).%PurgeIndices()
VOUCH>w result
1
VOUCH>set result = ##class(SQLUSER.MYTABLE).%BuildIndices()
VOUCH>w result
1
VOUCH>
Typing w(rite) result should give you 1 means success.
