回复:已经有index了。我们虽然不是data warehouse数据,但数据量很大。再加additional index

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.

所有跟帖: 

Well it is a real time system and the response time is critical. -simplylove- 给 simplylove 发送悄悄话 simplylove 的博客首页 (0 bytes) () 07/07/2014 postreply 20:25:25

Adding additional index will probably have negative impact on ou -simplylove- 给 simplylove 发送悄悄话 simplylove 的博客首页 (0 bytes) () 07/07/2014 postreply 20:26:52

请您先登陆,再发跟帖!