Greetings,
* Campbell, Lance (lance(at)illinois(dot)edu) wrote:
> Question:
> Should I use table partitions if my table meets the below parameters? The size of the table should remain relatively consistent in 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