Re: Running 4GL on table that changes a lot

Dirk Moolman said: > > I think this is in the CDI archives, but I haven't found it yet. If > memory serves me right, it was discussed on this list some years ago. > > Some of our programs run batch processes, dropping & creating tables, > and then inserting lots of records into them ... BUT, and this is my > problem, the program also reads from the tables being inserted into. > > Because these tables are recreated, no (update) statistics exist on > them. But I also can't create them, run update stats and then read from > them - the reading and inserting happens at the same time. > > How do I overcome this problem ? Hope my question is clear enough. Well, let's start again: do these tables have any indexes? If not, what difference will an update stats make? What is the actual problem that you think update stats will fix? -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco You're so stupid, you think martial arts are paintings by a sheriff... I went to the airport to check in and they asked what I did because I looked like a terrorist. I said I was a comedian. They said, "Say something funny then." I told them I had just graduated from flying school. -- Ahmed Ahmed sending to informix-list

How about : read from the existing table populate a tempoary table with the new data drop the old table and rename the temp table to the name of the old table