索引

索引操作：

ALTER INDEX

BUILD INDEX

CREATE INDEX

CREATE PRIMARY INDEX

DELETE

DROP INDEX

DROP PRIMARY INDEX

参考资料：

Indexing

CREATE INDEX

Views and indexes

CREATE PRIMARY INDEX catalog_primary ON catalog
CREATE INDEX table_type ON catalog(table_type)
CREATE INDEX offer_ean ON catalog(ean) WHERE (table_type = "offer")
CREATE INDEX offer_shop_id ON catalog(shop_id) WHERE (table_type = "offer")
CREATE INDEX content_ean ON catalog(ean) WHERE (table_type = "content")
CREATE INDEX offer_ean_country ON catalog(ean,country) WHERE (table_type = "offer")