Re: Oracle Table Spanning

From: Hans Forbrich <hforbric_at_yahoo.net>
Date: Sat, 24 Jan 2004 21:24:27 GMT
Message-ID: <4012E1E3.B36A97BF@yahoo.net>

Andrey wrote:
>
> Dear Daniel, there IS occurence when partitioning would not help - when all
> data at once is requered. You can partition table infinitely correct, but
> this would not help. As original poster noted, he can not change database
> and application design, so you helpfull comments are useless at this given
> case. It's seems like database optimization question, and not so easily
> answerable.
>

Please indicate how Partitioning (using Oracle's paritioning capability) will change database or application design.

(AFAIK, the capability does not redefine the table or indexes, but simply indicates how the table is laid out, similar in nature to the min and max extents, etc.) Received on Sat Jan 24 2004 - 15:24:27 CST