Directi interview question

two column having ip address stored.each row having a range(ip_address_to,ip_address_from,country) and country mapping to which the ip belongs. Question was wat will be the best structure to store it in sql as well as how to optimize it if queried such a table.

Interview Answer

Anonymous

27 Mar 2012

store ip address in long datatype column.have indexes in them