0 Replies Latest reply on Oct 7, 2013 1:03 AM by 1012994

    Multiple Columns vs Like Operator

    1012994

      Hi,

       

      The performance is very important for my application, so I need to know what is more expensive:

      - Use 18 numeric columns, and query using multiple OR operators.

      - Use 1 text column, and use the LIKE operator.

       

      Can create indexes to improve performance in both cases?

       

      Thanks!