Hi,

> I have always indexed my databases in the past to keep them at an
> optimum speed - recently I heard another programmer say that he
> refused to work with another index in his life because of the
> problems they cause , and the data corruption that occurs.
>
> Have I missed something?

Yes, was he talking about Paradox?

> Are there any problems with using interbase indexes? Is there another
> way to optimize a database?

I guess his data-access queries are slow without indices.

Besides, primary key, unique and foreign key constraints automatically
create indices in InterBase, so there's no getting around it. :)


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

See you at the First European Firebird Conference in May in Fulda, Germany
http://www.firebird-conference.com