Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  comparision of optimizers in SQL Serv & Oracle

Author  Topic  rw30 Starting Member 3 Posts Posted - 2009-10-03 : 07:02:12 can anybody help me with that ? ; ) give a hint or sth like that ? ; ) I have a presentation to make on that topic... from what I know and what I read both optimizers, in SQL Serv and in Ora work very similarly in the short overview: the foundation is collecting stats and then making [or, better said, calculating] the decision based on stats they are using very similar operations [identical joining algorithms, similar access methods, I mean table scan, index scan, index search etc. very similar structure are in use [heap/ unsorted tables, sorted:IOT tables in Ora/clustered index in sql srv, b-tree indexes in both, fucntion indexes in both] ] so what can I point as a difference ? or maybe there are some experiments on test environments that I can prepare to show the differences in making decisions by optimizers ? what do you think ? I know that the topic is 'comparision', so if the conclusion will be "well. uhmmmmm.... they are more or less the same.... ", that won't be the end of the world, but maybe some of you can help me somehow ; ) I know that school is my thing to handle, not yours but maybe some of you can help make my presentation better thx in advance & regards rw30 p.s. I'm gonna make the experiments based on 10R2 and sql 2005 version, as there is not much literature available for the latest versions