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.
