Temporary tables, pros and cons (1 Viewer)

[max1]

Hi,

I am vaguely aware that temporary tables do not have the best reputation.

I have recently started using temporary tables and I have found that I can make the db far more user friendly using temporary tables than without. I would like to use a whole lot more but I want to know if I am setting myself up for problems in the future.

All my temporary tables are created automatically using sql from within VBA procedures.

All my temporary tables are deleted automatically after use.

Thanks

 

[Anakardian]

I tend to use a permanent temporary table instead of creating and deleting it all the time.
Once I finish with the table I wipe the data so its ready for the next time.

For me it is easier than creating and deleting and as far as I understand it is faster as well.

 

[Thales750]

I tend to use a permanent temporary table instead of creating and deleting it all the time.
Once I finish with the table I wipe the data so its ready for the next time.

For me it is easier than creating and deleting and as far as I understand it is faster as well.

Same here, some of the tables are multi-function generic, others are specific.

The big advantage to writing data to a temporary tables, whether temp or permanent is that complex queries are often non updatable.