At a large retailer, adding a missing index to a small, 2,000-row table in an 8 TB warehouse reduced the elapsed time of a critical decision support query from three hours to two minutes.
在一家大型零售商的8 TB数据仓库中,在一个2,000行的小表上添加一个索引之后,一个决策支持查询花费的时间从三小时一下降到了两分钟。
Even at the low end of this scale, a 38 percent reduction in elapsed time is a significant improvement that is likely to have substantial cost savings for an organization.
在这些用例中,执行时间至少减少了38%,这已经是一个很大的提高了,对于一个企业而言,这可以节省相当可观的成本。
Over the length of the value chain, it's possible to look at the total effort in proportion to the elapsed time to give an understanding of efficiency.
对于价值链的长度,您可以查看总体工作量与消耗时间之间的比例,以理解效率。
应用推荐