创建索引原文:
CREATE INDEX "TheTickets_IssueTime_idx" ON "TheTickets" USING btree ("IssueTime")
执行第一次:
explain
select "Id" from "TheTickets"
where date("IssueTime") >='2019-01-01'
执行第二次:
explain
select "Id" from "TheTickets"
where date("IssueTime") >='2018-01-01'
执行结果如下图所示:
这就不懂了。。。