I'd say 2GB is just an arbitrary number - I don't know why they would
say that. Anyone else have any idea if there is something magical about
the 2GB size that would warrant partitioning? Sounds to me like they're
just saying that to help with sales of the Enterprise Edition and the
partitioning option.
Frequency of selects, inserts and deletes has nothing to do with
partitioning. It all depends on exactly *how* those operations are
being performed. For example, if you're doing a bunch of unique index
lookups and individual inserts and deletes, partioning isn't going to
help at all, but if you're performing full table scans or index range
scans that could be broken up by partitions or mass inserts/deletes that
could be done in partitions, then it could be a big help.
________________________________
From: laura pena [mailto:lizzpenaorclgrp@xxxxxxxxx]
It does say tables greater than 2gb should always be considered.
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c12p
arti.htm#459787
This table is is select, inserted and updated too very often.
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.