>From: DA Morgan <damorgan@psoug.org>
[SNIP]

Sigh.

This is a design issue that shows that while there are general concepts
which are the same across different platforms, there some subtle differences
which will impact performance.

The implementation of Temp tables in Oracle is wrong. Ugly, inefficient and
barely supports the idea of the "INTO TEMP" clause that I believe is part of
the SQL standard.

Now when I say "WRONG", I'm talking from a purely design perspective. (In
truth there is no right or wrong, its a question about how to interpret the
requirements and does the solution meet the stated goals. )

However, as a developer if I want to KISS (that's an engineering term), I
want to have my temp tables defined dynamically and be unique in that I
don't incur overhead or issues from other implementations.

The example I've used is that you can not create an index on a temp table if
the table has data anywhere. That is even if I trunc my data, a different
user could still have data in the temp table. So I can't create an index.
While this may seem like a small nit, its not. When you're doing some
computations on a subset, or need to create a functional index on the
subset. So creating and dropping indexes on subsets is not possible.

An example? Suppose I have a field where the value is a bitmask and I only
want to select a certain portion for processing. I can't easily do this with
Oracle's temp tables. Hence the issue.

The "right" solution allows the developer a lot of freedom and still
conforms to the spec. Hence the preference for IDS.

On a completely different topic, is the extensibility issue. (Don't get me
started on Oracle's "extensibility....". And to keep this issue simple, lets
talk about Sybase's adaptive server.

Its extensible, however, they didn't fence in the user/developer's code so
that if there is ineffcient code, it will kill the performance of the entire
database. Note that even if the code looks clean, it can still be
inefficient.

Again kudos to IDS's developers who thought things out before
implementations. ER/HDR anyone?

That is the point. Its a better designed system.

And DA, you keep citing statistics about open rec's for FTEs.

Here's an example I think you might be able to grasp.

Porsche doesn't have a "green" car in its line up. The company defended
itself by saying that if you took all the Porsche vehicles off the road,
you'd have a less than 1% impact on CO2 emmissions from automobiles.

So when you ask a customer, that for the same price, would you rather be
driving an econobox or a Porsche, what do you think they'll say? ;-)

__________________________________________________ _______________
You keep typing, we keep giving. Download Messenger and join the i’m
Initiative now. http://im.live.com/messenger/im/home/?source=TAGHM