Re: IOT seek vs index seek - index sizes and widths.

On 24 Apr 2007 04:28:13 -0700, phancey <deja_at_2bytes.co.uk> wrote:

> Realistically, you are not going to
>entirely ignore what you have spent time doing on one RDBMS as though
>it has no place in the other. It becomes your starting point and then
>you tweak it to optimize it for the second.

Just for your information: I suffer EVERY DAY from this approach. There are too many developers who think Oracle is just sqlserver sold by a different vendor, and this is why they 'port' their code, without adapting it. If I must guess who you are going to blame when disaster strikes, I KNOW it is the POOR Oracle DBA, who can't do much about it, except throw the application out of the window.

So realistically, knowing you can't tweak Oracle to behave like sqlserver, you either write a proper API, or you start all over again.

You are doomed to failed, DOOMED (Frazer in 'Dad's Army')

-- 
Sybrand Bakker
Senior Oracle DBA