When creating a hold file from and Oracle table and joining the hold file to an Oracle table, would it more efficient if the hold file were an Oracle table: ON TABLE HOLD FORMAT SQLORA?

This message has been edited. Last edited by: JohnB,

Absolutely. Also check out the SAME-DB option.

And do not forget the INDEX

ON TABLE HOLD FORMAT SQLORA INDEX field1 field2 etc.

Should have been more explicit,

Index if you want to join to it.

However there is another consideration that needs to be taken into account.

What mathod of access do you use to oracle?
If it is a generic WebFOCUS id (explict in WFS terms) then you may have potential issues
if this is for an end-user report.

The reason is that you must do a drop table if you are to reuse the name.

This potentially means that user B could drop the table while it is being used by
user A or perhaps pick up incorrect content if the failure to drop and create failed
because of system locks.

JG, what is a "drop table"?

John,

"drop table" is the SQL command to delete an SQL table.