Data Partitioning in Database
976910Feb 4 2013 — edited Feb 5 2013Hi All,
I have little bit confuse in data partitioning in database, I have read about it and i understand that there ate two type called vertical partitioning and another horizontal partitioning...
I have three questions are
1- is data partitioning used of in networks or can be in one PC?
2- the data partitioning divided data that in table to partitions (groups) , according what ??? is to quantity or meaning of data that inside table?
3- Is clustering that can be execute by Oracle using CTX_CLS.CLUSTERING type of it or partitioning not related to it?
Please let any one give short answer about it.
regards
Dheya