Re: is Oracle technically better than Ingres ?

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 - 14:38:56 CEST