gist index on cube column
Hi,
I had some doubts about the gist index on cube column. So if I have a
column of type cube and create a gist index on it, would the index be
on individual elements in the cube or the cube as a whole. I mean will
a gist index on cube column improve the performance of earthdistance
function or cube_distance function.
Thanks
Abhang
On Sat, Jun 09, 2007 at 07:40:05PM -0400, ABHANG RANE wrote:
Hi,
I had some doubts about the gist index on cube column. So if I have a
column of type cube and create a gist index on it, would the index be
on individual elements in the cube or the cube as a whole. I mean will
a gist index on cube column improve the performance of earthdistance
function or cube_distance function.
The index will work on any operators the index is defined to work on.
So I suggest looking at the documentation for what operators are
defined and whether they solve your problem.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
From each according to his ability. To each according to his ability to litigate.