Re: Should I use table partitions

Greetings,

* Campbell, Lance (lance@illinois.edu) wrote:
> Question:
> Should I use table partitions if my table meets the below parameters?  The size of the table should remain relatively
consistentin size and number of rows.  I would not expect it to vary more than 15% at any given time. 
>
> Info:
> Table rows: 83,051,164
> Table size only: 25.6 G
> Total size of table including indexes: 38.6 G

Just based on the above info, I'd tend to say "no".

Thanks!

Stephen