Re: Performance problem

From: Jeff Hunter <jeffh_at_btitelecom.net>
Date: Sun, 18 Jul 1999 23:19:44 -0400
Message-ID: <379298e4@defiant.btitelecom.net>

In RULE mode, the query will be using indexes if available whereas in CHOOSE mode, the statistics have to be computed in both databases for the objects in question. In comparing the two platforms, I would stick with RULE mode. Almost sounds like you are using indexes in one case and doing a full scan on the PC.

I would check both DB's for:

1. identical indexes in both dbs
2. identical extents in both dbs
3. similar init.ora parameters

You have got to remember, however, the the Sun will always be faster in the same query. No flames please, it's just a simple fact of life: RISC is faster than CISC. Received on Sun Jul 18 1999 - 22:19:44 CDT