i want to know the advantages of Table Partitioning.
when can one think of implementing table partitioning technique,i mean what should be the size of table be(i know there is no hard and fast rule for this)
are there any disadvantages of goin for table partitioning technique.
do we need have any special privillages to implement the partitioninig technique.
please let me know,