Ref: Performance

Hurray, Jack ! Seems like you could have answered like that the first time.... A soft answer ....(is better) I have a performance problem...and I hope it will not fall into the bad category. I added another index to a table in my database (the 6th one) and my performance took a turn for the worse. Where is the trade off, when are there too many indexes? How do most folks handle the need for indexes? Do they create temp tables for ace reports and have only 2 or 3 main indexes? We are doing very little 4GL, mostly .ace reports and perform screens with ESQL behind the the perform srcreen. Is 4GL faster? (I know, it depends on the data, design and hardware...), but is it possible to get the performance using temp tables instead of indexes? cheryl cheryl@redriverad-emh1.army.mil 903-334-3518