Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance problem
I forgot to mention tables, including indexes, data, extents, etc. are
completely identical.
I use indexes in both cases. Only thing that increases query run time is
distinct clause, otherwise qury is running very fast.
I also understand that Solaris is faster, but not 50 times faster, right?
thanks
Gocha
Jeff Hunter wrote in message <379298e4_at_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 Mon Jul 19 1999 - 07:14:12 CDT