On Thursday 21 August 2008, Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> wrote: > I've a large table with a pk and several smaller tables with fk > referencing to it. > > deleting from the first table is very slow. > > Not all the related fk have indexes but they are VERY small (0 to > 100 records) while the main table contain 600-800K records. > > the > explain delete p; > doesn't give any clue. > > Any hint to track down the problem? 1) Define slow. 2) Tell us what your disk subsystem consists of. 3) Are there any delete triggers on the tables? -- Alan
