视图和索引对性能的影响

Let's say I have a table foo:

假设我有一个表foo:

CREATE TABLE FOO (
    FOO_ID INTEGER,
    STATUS INTEGER,
    RATING INTEGER,
    PRIMARY KEY ("FOO_ID")
)
C