Places:Indexes
From MozillaWiki
Indexes
- CREATE INDEX moz_bookmarks_itemindex ON moz_bookmarks (fk)
- source
- CREATE INDEX moz_bookmarks_parentindex ON moz_bookmarks (parent)
- source
- CREATE INDEX moz_places_urlindex ON moz_places (url)
- source
- CREATE INDEX moz_places_titleindex ON moz_places (title)
- source
- CREATE INDEX moz_places_faviconindex ON moz_places (favicon_id)
- source
- CREATE INDEX moz_historyvisits_pageindex ON moz_historyvisits (place_id)
- CREATE INDEX moz_historyvisits_fromindex ON moz_historyvisits (from_visit)
- CREATE INDEX moz_places_hostindex ON moz_places (rev_host)
- CREATE INDEX moz_places_visitcount ON moz_places (rev_host)
- CREATE INDEX moz_places_hostindex ON moz_places (rev_host)
- CREATE INDEX moz_places_visitcount ON moz_places (visit_count)
- CREATE INDEX moz_historyvisits_fromindex ON moz_historyvisits (from_visit)
- CREATE INDEX moz_historyvisits_dateindex ON moz_historyvisits (visit_date)