Jim, On 4/20/06 6:36 AM, "Jim Buttafuoco" <jim@xxxxxxxxxxxxxx> wrote: > The access is very fast when looking for a small subset of the data. I guess you are not using indexes because building a (non bitmap) index on 6TB on a single machine would take days if not weeks. So if you are using table partitioning, do you have to refer to each child table separately in your queries? - Luke