Re: Bigger block sizes

Who or what would use an index on 4000 byte column in index and how? I am thinking it will not be a human input.

On Thu, Oct 1, 2015 at 11:32 PM, Mark Brinsmead <mark.brinsmead_at_gmail.com> wrote:

> One (sort of) legitimate use-case I came across was an inherited database
> where they used tablespaces with 32KB blocks to house indexes that required
> insanely huge keys.
>
> (Even with 32KB blocks, we were sometimes unable to create the indexes we
> wanted/needed, which often included multiple VARCHAR(4000) columns.)
>
> The application itself was highly unusual, and the underlying architecture
> even more so. (And I had nothing whatsoever to do with either of them.)
>
> Anyway, cases where you truly need indexes with really large keys will
> warrant block sizes greater than 8KB. With 8KB blocks, you are limited to
> something like 3916 bytes as your largest key. (Yes, I know -- that ought
> to be enough for most people. Did I mention that I had no input into the
> architectural decisions?)
>
>
>

--
http://www.freelists.org/webpage/oracle-l