On Wed, Oct 10, 2012 at 3:18 PM, Shaun Thomas <sthomas(at)optionshouse(dot)com> wrote:
>> Why does nobody every mention that concurrent access has to be taken
>> into account?
>
>
> That's actually a good point. But if you have one giant database, the
> overlap of which tables are being accessed by various sessions is going to
> be immense.
That's why I said "several huge indices". If regularly accessed
indices are separate, and big, it means they don't overlap nor do they
fit in any cache.