[Bizgres-general] partitioned tables and indexes

Bob Ippolito bob at redivi.com
Fri Mar 17 00:59:10 GMT 2006


On Mar 16, 2006, at 3:51 PM, Charly CLAIRMONT wrote:

> Hi,
>
> I have installed Bizgres on my server which has this features :
> OS : Fédora Core 4
> cpu : AMD 2.8 GHz
> RAM : 1024 Mo.
>
> I insert about 10 Go datas, I have partitinned my fact table following
> date. That is to say for each day , a daughter table. However I  have
> created my index on the mother table , not on the daugther (I think  
> that
> this indexes would propage on the daugthers). In fact I think I make a
> mistake ! No ?

Indexes are not inherited.

-bob




More information about the Bizgres-general mailing list