Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sybase vs Oracle - which is better?

Re: Sybase vs Oracle - which is better?

From: Michael Bilhartz <bilhartz_at_newsguy.com>
Date: 1998/12/04
Message-ID: <749mm8$djo@enews1.newsguy.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US