> -----Original Message----- > From: Gábor Farkas > > > i see. > > will i achieve the same thing by simply dropping that table > and re-creating it? Yes. Or even easier (if you don't need the data anymore) you can use the truncate command. Which deletes everything in the table including dead rows. Dave ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings