Hi Again,
> You have to optimize a large database (2 Million records).
>
since I have a huge amount of 'static' records (2 million and more)
which will not change any more, and on the other hand at about 2.ooo
(growing) records which are updated regulary, I wonder if its useful
having those static records in a seperate table...
The SELECT-queries go into a MERGE table which unites the 'dynamic' and
'static' record-table.
Will this speed up my Update-Queries, because the index in the
dynamic-table will be built up much faster?
thanks for your help.
Regards,
Andy
