COST BASED OPTIMZER INFO ??
From: Jeff K <102172.2033_at_CompuServe.COM>
Date: 1995/06/18
Message-ID: <3s1v3p$e0h$1_at_mhadg.production.compuserve.com>#1/1
Date: 1995/06/18
Message-ID: <3s1v3p$e0h$1_at_mhadg.production.compuserve.com>#1/1
I'm new to the ORACLE world, but have 8 years of DB2. I'm currently involved in a project to tune some batch processing and from past experience know that when accessing large amounts of data sometimes the best access path is not one which you might have guessed it would be. i.e. merge scan join, etc. The shop I'm in is still doing rule based optimization but I have very little info on the V7.0 cost based optimizer. Can anyone point me in the right direction or share any experiences they may have had with the cost based optimzer in 7.0 ?? Thanks a bunch. Received on Sun Jun 18 1995 - 00:00:00 CEST