raghurani
asked on
indexing vs partitioning
Hello,
Can you please provide us details on the (dis)advantages of partitioning when compared to indexing? We plan to support MS-SQL and MySQL platforms, to begin with.
Regards,
Raghu
Can you please provide us details on the (dis)advantages of partitioning when compared to indexing? We plan to support MS-SQL and MySQL platforms, to begin with.
Regards,
Raghu
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi,
Thanks for your quick responses.
First thought, angelIII: MySQL 5.x supports partitions! But, I agree with you that pre-5.x releases do not support partitions. As such we are OK to use MS-SQL 2005.
aneesh: I will visit the URL and get back to you.
Regards,
Raghu
Thanks for your quick responses.
First thought, angelIII: MySQL 5.x supports partitions! But, I agree with you that pre-5.x releases do not support partitions. As such we are OK to use MS-SQL 2005.
aneesh: I will visit the URL and get back to you.
Regards,
Raghu
>First thought, angelIII: MySQL 5.x supports partitions!
to be exact, it seems that with 5.1 partitionning get's available, I only know up to 5.0
to be exact, it seems that with 5.1 partitionning get's available, I only know up to 5.0
AW, can you explain why the delete?
Information has been given...
Information has been given...
I did not think that enough information was given for raghurani to get a useable answer, and he did in fact say (to aneeshattingal) that he/she would checkout the link and get back - and never made any further response.
It is not at all clear that simply telling raghurani that he/she could or could not use partitioning gave enough information to answer the original question, which had to do with the relative advantages or disadvantages of partitioning vis a vis indexing. The closest to an actual answer was from aneeshattingal, and that directed him/her to another web site, and he/she may or may not have actually looked into that site. The lack of any further response was the driving force behind the recommendation.
AW
It is not at all clear that simply telling raghurani that he/she could or could not use partitioning gave enough information to answer the original question, which had to do with the relative advantages or disadvantages of partitioning vis a vis indexing. The closest to an actual answer was from aneeshattingal, and that directed him/her to another web site, and he/she may or may not have actually looked into that site. The lack of any further response was the driving force behind the recommendation.
AW
well, it seems that everybody seems to (have) ignore(d) what I wrote in my first post... I wrote what the advantages and disadvantes of partitions are, although it is not really clear that "partitionning" vs "indexing" is a bad question.
you should (will) always use indexing, wether you use partitionning or not. Partitionning can help the indexing, but is not a replacement.
There are no other arguments in regards to partitions itself than "CONS"=more management needed and "PRO"=more management possible, and that partitions do not replace indexes, but are to be used in additions to indexes.
you should (will) always use indexing, wether you use partitionning or not. Partitionning can help the indexing, but is not a replacement.
There are no other arguments in regards to partitions itself than "CONS"=more management needed and "PRO"=more management possible, and that partitions do not replace indexes, but are to be used in additions to indexes.
ok. I give..
AW
AW
> Can you please provide us details on the (dis)advantages of partitioning when compared to indexing?
If you have smaller partitions, then the size of indexes will also smaller..
read this article .
http://www.sqlteam.com/Item.ASP?ItemID=684