Skip to Content

Second index on the same same column is not created

Hi,

I'm trying to create additional function based index on few tables:

-CSTICKETS

-MEDIAS

-ORDERS

-USERGROUPS

but indexes are not created. No errors in logs. Is any "optimization" which blocking creation of index with different name on the same column? For example for CSTICKETS I am trying create TICKETIDIDX_LOWER index on P_TICKETID attribute (default index on this attribute is created in ext-commerce/ticketsystem/resources/ticketsystem-items.xml). After system update index is not created and I cannot find any errors or warns in logs. Others indexes are created without any porblems.

I am using hybris 1811.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 28, 2020 at 09:14 AM

    Hi Mikolaj,

    This 'Oracle Database' Tag is usually takes reference to SAP NW based Oracle issues.

    Our position with Function-Based indexes in a SAP NW System is that our customer can use this but no support provided. This is documented in below SAP note:

    105047 - Support for Oracle functions in the SAP environment

    But, besides this you can maybe try to create the index as 'invisible'.

    However, since you are using Hybris, I recommend to use some additional tags like "SAP Commerce Cloud".

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.