Re: Select performance vs. mssql

Folks,

> > This gets brought up a lot. The problem is that the
> > index doesn't include
> > information about whether the current transaction
> > can see the referenced
> > row. Putting this information in the index will add
> > significant overhead
> > to every update and the opinion of the developers is
> > that this would be
> > a net loss overall.

Pretty much.  There has been discussion about allowing index-only access to
"frozen" tables, i.e. archive partitions.  But it all sort of hinges on
someone implementing it and testing ....

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco