Re: [SQL] Question about a CIDR based query

Hi Josh, Ok, first the explain analyze June_03=# explain analyze select * from tmp where route >>='62.1.1.0/24'; QUERY PLAN --- Seq Scan on

Re: [SQL] Question about a CIDR based query

I did a vacuum analyze before I run the following explain June_03=# explain select * from tmp where route >>='62.1.1.0/24'; QUERY PLAN Seq Scan on tmp (cost=0.00..606.60 rows=1