GiST and SP-GiST indexes can be created for table columns of temporal poses. 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 poses, which is an stbox
, as all temporal spatial types.
A GiST or SP-GiST index can accelerate queries involving the following operators:
<<
, &<
, &>
, >>
, <<|
, &<|
, |&>
, |>>
, which only consider the spatial dimension in temporal poses,
<<#
, &<#
, #&>
, #>>
, which only consider the time dimension in temporal poses,
&&
, @>
, <@
, ~=
, -|-
, 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.