> >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.

Consider

> the corruption that could occur if such indexing were possible and

an

> external application deleted records or changed indexed values...
>
> The "trick" is to recognise that external tables are just a holding

place

> for external data.

Hi Helen...Thanx for your answer... But let me explain my case
especifically...

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
time...

What can i do in this case??... the external tables are my best
solution, but velocity is the price....

Best Regards

Carlos G