Difference between RTC Indices and Database indices
![]()
Hi,
We have repotool commands to create Text and workitem indices from RTC.
Now, in our Oracle Database, we have DB command to create indices.
My question is
1) Assume that we have an activity of splitting Bigfile table space to multiple tables . Following this, from the DB end, we will build indices in RTC
2) Again on RTC application end, do we have to run repotools command to rebuild text and workitem indices ? Can we not use the earlier built RTC workitem and text indices to look into the Database ?
How is running repotools command to build indices is different from building indices directly from Database ?
I'm looking at minimizing the time to build indices with RTC shutdown. If running indices in Database will be more than sufficient, then i would not prefer to run repotools command to build Text and Workitem indices.
|
2 answers
![]()
Ralph Schoon (63.3k●3●36●46)
| answered Dec 27 '14, 5:13 p.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Please read https://jazz.net/library/article/1271 and the second part to understand what the indices do. Please read https://jazz.net/wiki/bin/view/Deployment/BackupCLM to understand how backup works.
You would only have to rebuild text indexes or database indexes in case of fatal issues - e.g. the loss or inconsistency of indexes. This would likely be due to some error indicating the indexes are compromised or due to support asking to do so. As the application knows how the indexes are to be build, you should use the repotools command that supports it. You should not introduce indexes on DB level - unless support suggests to do so. |
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.