Re: Partition

T wrote:
> "DaFT" <gbaland_at_gmail.com> wrote in message
> news:1137154570.786332.149490_at_g14g2000cwa.googlegroups.com...
>> In fact I receive a lot of information (+/-1.000.000 record) per
>> week...
>> Each week are in a partition...
>> And when I must do a research to a date, I determine the partition
>> and I search on it...

Um, the optimizer should do that for you if

• you have a timestamp column in your table
• that column is part of an index
• and you use columns from the leading part of that index in your query (including the timestamp) for filtering

No need for manual intervention here.

>> But for the old value, all the records are on the same partition...
>>
>> Thanks for the solution ;)
>>
>
> alter table add column godina and
> try to make partition over week and year...

Or just timestamp.

    robert Received on Fri Jan 13 2006 - 09:11:31 CST