回複：請教oracle db問題

first step is index. You real need to think how to create index based on your query.
becareful of your transaction, try make it as small  as posible.
alter solution is dump data into temporary table, and working on temporary table. This way, usually you do not need cursor.

所有跟帖： 

• 已經有index了。我們雖然不是data warehouse數據，但數據量很大。再加additional index -simplylove- ♀ (224 bytes) () 06/23/2014 postreply 19:16:51

• 我覺得隻能用temp table了。問DBA也不做聲 -simplylove- ♀ (12 bytes) () 06/23/2014 postreply 19:22:21

• 回複：已經有index了。我們雖然不是data warehouse數據，但數據量很大。再加additional index -lidongmei- ♂ (17866 bytes) () 06/24/2014 postreply 09:02:52

• 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