Re: Is Oracle slower than sql server

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: 26 Jul 2006 06:47:10 -0700
Message-ID: <1153921630.731756.129460@p79g2000cwp.googlegroups.com>

faisal.mansoor_at_gmail.com wrote:
> all the tables and stored procs are
> identical

And here you are trapped!
Most probably you created your procedures at first on SQLServer and directly ported them on Oracle. If so let me guess that you are using some of following constructions:

1) creating and dropping tables on the fly
2) using plenty of user defined functions in DML statements
3) creating wide outer joins with little restrictive base record set

and discarding at least half of returned result on client 4) creating multi union selects of the same data source instead of simple grouping
5) commiting as mad
6) haven't analyzed your schema and haven't looked at any of your sql statement explain plans
7) using default Oracle configuration with for example choose or all_rows optimizer goal for your _OLTP_ application.

At least these were the most common mistakes I found for our MS SQL programmers trying to create database independent application both for Oracle and MS SQLServer.

I can only agree that you should read previously mentioned books and get the feeling how the very architecture of Oracle is different from MS SQLServer.

Gints Plivna
http://www.gplivna.eu Received on Wed Jul 26 2006 - 08:47:10 CDT