Details
- 
    Improvement 
- 
    Resolution: Unresolved
- 
    Major 
- 
    None
- 
    6.3
- 
        Unknown
- 
        
Description
See the entire discussion on XWIKI-8691 about the need for automatically adding function based indexes (e.g. lower(DOC_FULLNAME)) for having a good performance with case insensitive queries that are currently not using any index at all.
Options:
- Use Hibernate's database mapping file when initializing a database (currently problematic, see XWIKI-8691's comments)
- Use liquibase schema manipulation during a data migration
Attachments
Issue Links
- is related to
- 
                    XWIKI-8691 Sorting in the Livetable is case sensitive -         
- Closed
 
-