Re: A thought on Index Organized Tables

On Wed, Feb 24, 2010 at 4:12 PM, Gokulakannan Somasundaram
<gokul007@gmail.com> wrote:
> Sequential scans can be done on IOTs, just scan through the leaf pages.

That doesn't work because when you split an index page any sequential
scan in progress will either see the same tuples twice or will miss
some tuples depending on where the new page is allocated. Vacuum has a
clever trick for solving this but it doesn't work for arbitrarily many
concurrent scans.



-- 
greg