On Wednesday 06 Nov 2002 5:09 pm, Douglas Blood wrote:
> Does anyone know why a drop of a table takes longer than a copy out? or a
> select *? and is there any way that i could speed it up?
Do you have a lot of constraints (foreign keys and other triggers) on this
table? If so, dropping these first might well sort things out.
--
Richard Huxton