Please run ANALYZE TABLE <table-name> ESTIMATE STATISTICS SAMPLE 10 PERCENT
on both tables? Then try again?
on 3/11/04 6:35 AM, Huascar Espinoza at hespinoza_at_superele.gov.bo wrote:
> To realize the test, we have the basic following structure (similar on Oracle
> 9i and SQL Server 7.0):
>
>
> · Table ³SC_FACTURACION² have the following indexes:
>> * COD_IMPORTACION
>> * NRO_FACTURACION
>> * COD_FACTURA_ESTIMADA
>> * COD_FACTURA_REFACTURADA
>> * COD_MOTIVO_ESTIMACION
>> * COD_NIVEL_CALIDAD.
> · Table ³GE_HISTORICO_IMPORTACION² has 30 registers.
> · Table ³SC_FACTURACION² has 1,885,618 registers.
>
> On ŒSC_FACTURACION¹ we execute the following SQL sentences:
>
> 1. SELECT COUNT(NRO_FACTURACION) FROM SC_FACTURACION WHERE COD_IMPORTACION =
> '14' AND COD_NIVEL_CALIDAD = '1'
> 2. SELECT MAX(NRO_FACTURACION) FROM SC_FACTURACION WHERE COD_IMPORTACION =
> '14' AND COD_NIVEL_CALIDAD = '1'
> 3. SELECT MIN(NRO_FACTURACION) FROM SC_FACTURACION WHERE COD_IMPORTACION =
> '14' AND COD_NIVEL_CALIDAD = '1'
>
> The results are:
>
>
> Sentence Performance ORACLE 9i Performance MS SQL Server 7.0
> 1 2 minutes 20 secs.
> 2 2 minutes 1 sec.
> 3 50 secs. 1 secs.
>
> The servers are the followins features:
>
> ORACLE 9i Server
>
> Processor Intel Pentium IV - 2.4 GHz
> RAM Memory 512 MB
>
> S SQL Server 7.0 Server
>
> Processor Intel Celeron 2.4 GHz
> RAM Memory 380 MB
>
>
> Please let me know, why the performance of Oracle is so low.
>
> Thank you!
>
> Huáscar Espinoza
>
>
> -----Mensaje original-----
> De: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En
> nombre de DENNIS WILLIAMS
> Enviado el: Jueves 11 de Marzo de 2004 9:16
> Para: 'oracle-l_at_freelists.org'
> Asunto: RE: Oracle Performance
>
> Huascar
> Normal? No. In order to help diagnose your situation, please post more
> details. Like your query, the sizes of your tables, etc. Have you analyzed
> the tables in Oracle?
>
>
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On
> Behalf Of Huascar Espinoza
> Sent: Thursday, March 11, 2004 7:04 AM
> To: oracle-l_at_freelists.org
> Subject: Oracle Performance
>
>
>
> ¿Is it normal that a SQL sentence: MAX or MIN, execute over 1.5 minutes on
> Oracle 9i, and in 1 sec. on SQL Server 7.0 (2 millions of registers), using
> equals data structures and servers? ¿Why occur this situation?
>
>
>
> Thank you,
>
>
>
> Huascar Espinoza
>
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Thu Mar 11 2004 - 14:12:49 CST
