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行的小表上添加一个索引之后,一个决策支持查询花费的时间从三小时一下降到了两分钟。
For example, consider a federated union query across three sources.
例如,考虑一个跨三个数据源的联邦联合查询。
As you can see, the query was executed three times, and the average elapsed time is about 307 seconds, which is very slow.
如您所见,查询执行了三次,平均运行时间大约是307秒,非常慢。
应用推荐