Indexing

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:

These operators work on bounding boxes, not the entire values.