ALLIO optimizes with the goal of running the entire query to completion in the shortest amount of elapsed time.
若优化目标为ALLIO,则可以以最短的时间完成整个查询。
In this case, the ALLIO run for the first query was significantly faster than the FIRSTIO run in the time it took to return all 12 rows.
在这种情况下,对于第一个查询,与使用FIRSTIO优化目标相比,使用ALLIO时返回全部12行所需的时间明显更短。
应用推荐