查询优化集中于cpu密集型(CPUbound)执行路径,而全缓存数据库将仍然集中于优化取页到大容量存储器的操作,而这已不再是问题。
Query optimization focuses on CPUbound execution paths, while a fully cached database will still be preoccupied with optimizing page fetches to mass storage that are no longer an issue.
对数据仓库多维视图进行容量估计是数据立方体设计、数据仓库存储规划和实施查询优化的基础。
Size estimation of multidimensional views of data warehouse is a fundamental step for data cube design, warehouse storage planning, and query optimization.
应用推荐