回複：已經有index了。我們雖然不是data warehouse數據，但數據量很大。再加additional index

來源: lidongmei 於 2014-06-24 09:02:52 [檔案] [博客] [舊帖] [給我悄悄話] 閱讀數 : (17866 bytes)

回答: 已經有index了。我們雖然不是data warehouse數據，但數據量很大。再加additional index 由 simplylove 於 2014-06-23 19:16:51

Generally speaking, "index" will not impacting other processes. Only a little slow down when insert data. Based on what you said here, definitely you need your report "index". Create an index based on your query condition.
Yes, you need DBA help.

您的位置：文學城 » 論壇 » 實用電腦 » 回複：已經有index了。我們雖然不是data warehouse數據，但數據量很大。再加additional index

所有跟帖：

• Well it is a real time system and the response time is critical. -simplylove- ♀ (0 bytes) () 07/07/2014 postreply 20:25:25

• Adding additional index will probably have negative impact on ou -simplylove- ♀ (0 bytes) () 07/07/2014 postreply 20:26:52

請您先登陸，再發跟帖！