Re: is Oracle technically better than Ingres ?

From: michael newport <michaelnewport_at_yahoo.com>
Date: 3 Aug 2004 05:38:56 -0700
Message-ID: <63b202d.0408030438.fbe8e64@posting.google.com>

look at it this way,

using Oracle 9i, I have now written a batch procedure in PL/SQL that collects lots of data from various tables, and puts it all into a new table. I also did the same using Ingres 6.4 some time back using only SQL, running from a cron job.

In Oracle, when the user runs a report (the next day) from the table, it is slower than it should be as the 'order by' is done at run time. It seems that I cannot pre-order the data (though I have tried).

In Ingres I used to do this easily with :- modify <table> to btree unique on <field1>, <field2>, <field3>

Regards
Michael Newport Received on Tue Aug 03 2004 - 07:38:56 CDT