MySQL Forums
Forum List  »  Partitioning

Re: Partitioning VS index
Posted by: Mikael Ronström
Date: September 12, 2007 11:30AM

Hi,
Soft Li Wrote:
-------------------------------------------------------
> Partition a table by a date column VS index the
> table by the same column, what's difference? I
> think they both can improve query speed.

They can but in different ways so you can do both.
Indexes improve matters when you use the index
but partitioning can still be useful in very large
tables where the index depth is smaller if you
partition the table. Index is normally the first
step.

Rgrds Mikael

Options: ReplyQuote


Subject
Views
Written By
Posted
5633
September 12, 2007 01:11AM
Re: Partitioning VS index
3584
September 12, 2007 11:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.