On Monday 24 April 2006 10:43, Richard Huxton wrote: (...) > Do these two not solve your problem? I knew those solutions, I was looking for a new one ;-) Because the " open in execute" forces you to scan the whole table, that's what I wish to avoid, and the "select count(*)" will be able to use index scan (faster) (in version 8.1 ?)
Thank you for helping, Regards, D. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
