Re: Question about table partitioning.

From: Martin Drautzburg <drautzburg_at_altavista.net>
Date: 21 Apr 2001 16:32:35 +0200
Message-ID: <87k84egw70.fsf@altavista.net>

java2e_at_yahoo.com (Kev.-) writes:

> Hello,
>
> The table I have will become very large over time 50+ million rows.
> Would I be better off partitioning the table to get better
> performance? If I do this how much speed can I gain from it?

The main benefit of partitioning is that you can delete data more easily. Performancewise partitioning is not better than an index, you may however get performance benefits in situations when an index would normally not be used. Received on Sat Apr 21 2001 - 09:32:35 CDT