userpresencedata_pkey |
CREATE UNIQUE INDEX userpresencedata_pkey ON ONLY
public.userpresencedata USING btree (keyid, startdate) |
userpresencedatastart |
CREATE INDEX userpresencedatastart ON ONLY public.userpresencedata
USING btree (startdate) |
userpresencedatastartltc |
CREATE INDEX userpresencedatastartltc ON ONLY
public.userpresencedata USING btree (startdateltc) |
userpresencedatatype |
CREATE INDEX userpresencedatatype ON ONLY public.userpresencedata
USING btree (timetype) |
userpresencedatauser |
CREATE INDEX userpresencedatauser ON ONLY public.userpresencedata
USING btree (userid) |
userpresencedata_timetype_startdateltc |
CREATE INDEX userpresencedata_timetype_startdateltc ON ONLY
public.userpresencedata USING btree (timetype, startdateltc) |
userpresencedata_startdate_cover |
CREATE INDEX userpresencedata_startdate_cover ON ONLY
public.userpresencedata USING btree (startdate) INCLUDE (id, userid,
startdateltc, systempresenceid, presenceid, presencetime, routingid,
routingtime) |