Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sybase vs Oracle - which is better?
P. Larsen wrote in message <740ue7$7ng11_at_news.uscg.mil>...
>To me, thinking of temporary
>tables still "smells like" thinking of files. And THAT is a relational
>database misconception I've seen in many Oracle programmers ... resulting
in
>many program problems and strange designs.
Funny, that's the way I feel about cursors. Someone can't conceptualize a solution relationally, so they process the data procedurally.
I think that temp tables are sometimes a crutch, for not being able to conceptualize a single relational expression to get from here to there. They break it into chunks that they can be dealt with with just a couple of joins, or that they can optimze more easily.
Some people use cursors and temp tables, though, because they are the best or only way to do some things.
Regards,
-Mike Bilhartz
Received on Fri Dec 04 1998 - 00:00:00 CST
![]() |
![]() |