Re: Effect of relocating the table on the indexes of that table.

Thread View: comp.databases.ingres

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by mal@adc.com (Mic Mon, 13 Sep 1993 12:45

#3941

Author: mal@adc.com (Mic
Date: Mon, 13 Sep 1993 12:45

29 lines
1069 bytes

>From: msuhas@shakti.ncst.ernet.in (suhas Joshi)
>Subject: Effect of relocating the table on the indexes of that table.
>To: info-ingres@MATH.AMS.ORG
>
>In Ingres the database can be divided into multiple partitions
>We have a huge database nearly 100 Mb. We are now deviding that
>database into multiple locations. What I am interested in is that
>is there any problem when we move indexed or btreed tables to
>new location with the relocate command.
>
>Need a help...
>Please answer or mail to : msuhas@shakti.ncst.ernet.in
>			or joshi@cmcb.ernet.in
>			or ssuhas@shakti.ncst.ernet.in
>

100 MB is not very big.  Also, you neglect to mention what version
of INGRES you are running.  If you are running anything past 6.3 you
shouldn't have any problems with multiple locations.  You can even
spread a single table across several locations.



Michael Leo                       Disclaimer: My employer doesn't take
ADC Telecommunications                        me seriously, neither should
(612) 936-8305 (voice)                        you.
mike_leo@adc.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads