I have a search action the filters 5 text fields with an ‘or contains’ condition for each field. Is it more efficient to do it this way or to add a column in the query with all data aggregated into one field and just search this with a ‘contains’ condition? It is an MSSQL database 5K records and fields are all varchar with <75 characters.
Just curious about your thoughts.
Thanks