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: 300
sql
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