I have a testbox where enabled oracle case insensitive feature immediatly after ARS 19.02 install and continued installation of ITSM with it. There I have IB function based indexes.
If you haven't enbled the feature you will not have IB function-based indexes but only the normal (PK_B) ones. But then your I<> indexes should also be Normal indexes not function based once. Have you checked this?
I don't think I heard you exactly. Maybe I did.
I've never seen PK-B indexes as an equal substitute for IB indexes. The number is also completely different, much more IB than PK-B indexes. PrimaryKey and unique index is not the same.
If I understand you correctly, do you only have IB indexes if you set functional indexes? So how is performance access supposed to occur when functional indexes are not enabled?
Maybe we have a misunderstanding.
Please can you explain with an example, which IB indexes you are missing on a typical itsm form eg. HPD:Help Desk along with its ddl?
There weren't that many answers!?
- Do you (still) have IBxxxx indexes in your system?
- Also in a fresh installation?
- Do they really depend on functional indexes?
Currently I‘ve installed AR only and miss all IBxxxx indixes.
2 of 2 people found this helpful
Hi Stefan Hall,
I don't have 19.02 upgrade or fresh install yet. Do you see PK_ indexes instead?
Table B1020, previously had IB1020 index and now it should have PK_B1020
I don't exactly remember but from 9.x version BMC started adding Primary Key on field id 1 instead of adding unique index, that applies to all T, H and B tables. But If you were upgrading then installer was so intelligent never converted the existing indexes. ( I had to do it myself, discovered when i created new form then it created the Entry ID/Request ID field index as PK_T<new form id> etc.)
Thank you Mohammad, I'll take a closer look.
Then I would have to find in a fresh installation all former unique IBxxxx indexes as PK indexes. I am curious and must now unfortunately wait until tomorrow. My working day is already over
1 of 1 people found this helpful
a short intermediate information.
- The BMC support and DB expert first claimed that there is no difference between fresh and upgrade. You pay very close attention to this. However, it took only a few hours, and can be clearly proven.
- Then I asked for instructions on how to clean up all the old forms, taking into account our functional indexes (binary_ai). I received the constraints command, as Google displays it after 2 seconds. Very annoying ... to be continued.
Otherwise we are working on a general implementation ourselves, but binary_ai doesn't make it any easier.
I'll keep you and everyone else up to date here.