Big tables

[l.dyer@mgn.co.uk]

We have an Rdb database on VMS (Powerhouse 710g1) that contains only one
table. This table contains some 48,000,000 records which we wish to update
in a timely fashion.

We have dropped all the indexes and are proceeding to update with QTP.

We obviously have the option of running an SQL script if necessary.

I realise that we can use RMU to create a flat file which we can update and
reload, but I am not sure that this will significantly reduce running time.

Does anyone have any comments on the above alternatives or any other
methods that may significantky reduce update time.

Lynden


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.