Thread: table drops

table drops

From
"Douglas Blood"
Date:
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?


Re: table drops

From
Richard Huxton
Date:
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