Fixing my brain farts :-(
<snip>
> Run your "current status" queries against the "current" table while if
you
> want in-depth history of a particular flight, use the "history" table.
> This will increase your responsiveness considerably as there should be
> only 1 record per active flight in that table.
I meant to say one record per flight in the Curent table.
>
> There are several ways to approach this:
>
> a) INSERT everything into the history table then on a periodic basis,
> regenerate the Current table.
> b) INSERT records into both tables and DELETE the old one from the
history
> table.
Again, I meant to delete the old records from the Current table, not the
history table.
My apologies to the list!
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.