I'm storing some timestamps as integers (UTF) in a table and I want to query by <= and >= for times between a certain period. The table has gotten quite large and is now very slow in querying.
I think it's time to create an index for the timestamp column.
Uh, yeah.
I tried using an rtree (for <= and >= optimization):
Bad idea.
Do I have to create an rtree type for my timestamp integer column?
Why do you want an rtree index? They're for multidimensional polygonal data and stuff. Just create a normal index...
Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
