Will Indexing Binary Columns Improve Performance for SQL WHERE BETWEEN statements?

Posted by thenonhacker on Stack Overflow See other posts from Stack Overflow or by thenonhacker
Published on 2010-04-09T22:03:00Z Indexed on 2010/04/09 22:33 UTC
Read the original article Hit count: 296

Filed under:

I have a table that has a binary column that represents IP Address data. One of the queries perform a BETWEEN comparison on that binary column.

If I index that column, will performance improve for the BETWEEN comparison in the SQL Statement?

© Stack Overflow or respective owner

Related posts about sql