Aggregate Tables 回複:scan-buffer-delta only

來源: newstoall 2009-06-05 04:22:31 [] [舊帖] [給我悄悄話] 本文已被閱讀: 次 (330 bytes)
你不用次次都從頭走到尾巴
不是SQL專家的回答

Even you always need process from the head to the tail, you can pre-generate some aggregate tables to improve the performance.

Depending on how accurate you want, the aggregate tables can be generate at night and of course you need use aggregate awareness SQLs.
請您先登陸,再發跟帖!

發現Adblock插件

如要繼續瀏覽
請支持本站 請務必在本站關閉/移除任何Adblock

關閉Adblock後 請點擊

請參考如何關閉Adblock/Adblock plus

安裝Adblock plus用戶請點擊瀏覽器圖標
選擇“Disable on www.wenxuecity.com”

安裝Adblock用戶請點擊圖標
選擇“don't run on pages on this domain”