Q: update statistics
Posted in 1996
Hi, I'm trying to run update statistics medium/high in InfoOnline 6.x on a SCO machine with 64MB memory, and all I get is "cannot allocate memory"!? I don't know the exact size of the DB, maybe that of my 2-year-old son. Is upstat THAT resource-consuming? Hoops, I forgot that we recently had some problem with order by, where the same runtime-error occurred in our SQLwindows-based app, but there were only 10 lines or so to sort. I read about some envvar DB/SORT/TEMP/DIR/SPACE, shake it well, and you get the name, in the meantime I keep looking for my memory. advTHANKSance, Patrick -- Patrick Preuss + ppr@deckard.hb.north.de "Replikanten sind wie jede andere Maschine: sie koennen ein Nutzen sein, oder eine Gefahr. Wenn sie ein Nutzen sind, ist das nicht mein Problem."