MySQL Forums
Forum List  »  Partitioning

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

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

Rgrds Mikael

Options: ReplyQuote

Written By
September 12, 2007 01:11AM
Re: Partitioning VS index
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.