BOR15K (12/5/2016)
I have a table of several millions of records for flight ticket. One of the indices is Flight Ticket, so when user searches for ticket 1234567 or 123456% all is perfect. Now there is a requirement to also allow %234567 search, which obviously runs for too long (10 - 15 minutes). Is there any suggestion / approach / alternative / documentation what should be done in those cases, please?Much obliged.
One option is to have a reverse copy column, the search would then be "765432%", somewhat simpler than full text indexing.
😎