回複：已經有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- ♀ (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