GiST and SP-GiST indexes can be created for table columns of temporal networks points. An example of index creation is follows:
CREATE INDEX Trips_Trip_SPGist_Idx ON Trips USING SPGist(Trip);
The GiST and SP-GiST indexes store the bounding box for the temporal network points, which is an stbox and thus stores the absolute coordinates of the underlying space.
A GiST or SP-GiST index can accelerate queries involving the following operators:
<<
, &<
, &>
, >>
, <<|
, &<|
, |&>
, |>>
, which only consider the spatial dimension in temporal network points,
<<#
, &<#
, #&>
, #>>
, which only consider the time dimension in temporal network points,
&&
, @>
, <@
, ~=
, and -|-
, which consider as many dimensions as they are shared by the indexed column and the query argument.
These operators work on bounding boxes, not the entire values. In addition, a GiST index can accelerate nearest neighbor queries involving the |=|
operator.