Re: SQL Tuning

On Sat, 05 Jul 2003 15:04:14 GMT, - (-) wrote:

To all the 5 above that responded to my remark that I found it not cost effective to work with the CBO. I actually meant that I did not like the RBO and the CBO as I am a developer. As a developer I would prefer using a ESR (External SQL Rewriter). As some of these products I asked questions about offer or are. Saying that I also realise that these ESR or other tuning apps are expensive so I will just need to see if they are too expensive and if they are consider just buying a book for me and my DBA to go through and look at any other cheap and free aids. Another problem is it would also take some effort on the part of our DBA and I do not think he will be very happy with that idea as he already is busy enough with other stuff. Please keep in mind that we only have one DBA for a lot of Oracle Database installations and he also does unix stuff. So the guy has his hands full. Received on Mon Jul 07 2003 - 23:14:37 CEST