...so anyway I have not had time to implement the IOT suggestion
(people keep giving me other work !), but its nice to know that I can
do the same thing in Oracle that I used to do in Ingres. So thanks for
the help.
But pre-ordering your data is a handy feature that saves time (during
the day) and hassle.
But getting back to my original question, "is Oracle technically
better than Ingres". I still can not say that it is. I was waiting for
a smoking gun from some Oracle people as to why Oracle is better.
Furthermore I kept having an Oracle "snapshot too old" problem which
meant that after weeks of studiously putting my SQL query together, I
am now having to split it up again. Something to do with the query
taking too long.
regards
Mike