Hi,

I have been reading about partitioning and how it inproves performance of of queries in case of very large tables.

1. My question is how large is large enough to partition. When do you decide that the table needs partioning... when it has grown very large or when you know its gonna be very large in future.

2.what are the performance implications if you partition a small Table

3. What are the issues one will face when dealing with partioned Tables.

Thanks