I have been experimenting with index to speed up some views I have.
But it seems I have over done it.

I'm just about the delete a lot of them, so there will be around 10
left.

I'm just going through all my tables.


Thanks
Michael

--- In ib-support@yahoogroups.com, "Ann W. Harrison" <aharrison@i...>
wrote:

> At 09:21 PM 1/9/2003 +0000, Michael Vilhelmsen
> <Michael.Vilhelmsen@M...> wrote:
>
> >If I have a table in my DB which contains 60 fields, and I have
> >created 40 index' (20 asc and 20 desc).
> >
> >Will this affect the speed of an insert ?
>
> Yes. This seems to be my morning for being blunt, but may
> I ask why you created 20 ascending and 20 descending indexes?
>
>
> Regards,
>
> Ann
> www.ibphoenix.com
> We have answers.