Re: How to speed up 8i
From: Kevin Gillins <k.gillins_at_verizon.net>
Date: Mon, 23 Sep 2002 15:21:17 -0400
Message-ID: <amnpsg$ofg$3_at_nntp-m01.news.aol.com>
Date: Mon, 23 Sep 2002 15:21:17 -0400
Message-ID: <amnpsg$ofg$3_at_nntp-m01.news.aol.com>
"Tobie Berthon" <tberthon_at_adapsys.ca> wrote in message
news:e9946f43.0209230656.329ffb0c_at_posting.google.com...
> Hi All,
> We have migrated our databases from 8.0.5 to 8.1.7. We are
> having a real problem speed. A number of our programs now take twice
> as long to run as they used to. Any suggestions on what I can look at
> to try to kick up the speed on the 8i? Thanks!
Did you look at the rule based v.s. cost based optimizer? Have you collected statistics? Read about it in the doc.
Kevin Received on Mon Sep 23 2002 - 21:21:17 CEST