回复：请教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