Re: Partitioning VS index

[Mikael Ronström]

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