Places:Indexes

From MozillaWiki
Jump to: navigation, search

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)