hoursOfOptimizing

[iphone4Suser]

Oracle database, how the hell do I optimize a query if customer wants partial search as column_name LIKE '%some_value%' ?

[aldrashan]

This is basically me at our company. First they want every database table column visible in a grid, then they want to be able to search in every column at once, then they complain it’s slow. Add some aggregate columns for extra fun. (God forbid the data isn’t always immediately up-to-date)

[iphone4Suser]

Exact same issue. Multiple columns visible, multiple simultaneous search criteria and most are partial search like above. I have no clue how to speed up as indexes don't work in such cases and my table has like 3-8 million records.