Subject Re: [firebird-support] Re: External Tables with Indexes
Author Helen Borrie
At 11:07 PM 2/09/2003 +0000, you wrote:
> > >Are there any way to use Indexes in External Tables??... i've been
> > >trying with IB 6 but that is not allowed i think....
> > No, because these data are not controlled inside the database.
> > the corruption that could occur if such indexing were possible and
> > external application deleted records or changed indexed values...
> >
> > The "trick" is to recognise that external tables are just a holding
> > for external data.
>Hi Helen...Thanx for your answer... But let me explain my case
>I have an IB6 Database of a few years old, and it's size is so big
>for it's age.... the reason for that size is that i need to storage
>information about the end of exercises and movements for each month
>and that information is so much...
>So i was thinking about get out that information from the GDB using
>external tables, then i can reduce the size of GDB and
>consecuentially the GBK size too and my reports and query's still
>like today... but the problem is that the query's works but are so
>slow, because there are not indexes and the joins take a lot of
>What can i do in this case??... the external tables are my best
>solution, but velocity is the price....

You're clearly not looking at a shortage of local disk space here, since
you are willing to push data out to external tables, which must stay on
local disks. The size of the database doesn't affect performance. If the
presence of these old rows interferes with your operations on current rows,
why not move these old rows to a history table inside the database?