Re: Performance of temp table.

Jayakumar George wrote: > > Hi all, > > Environment : Running 7.23 online on Sequent Dynix PTX. > > Question. > In one of our programs , we create a temp table and during the > processing part it is populated for each processing period(dates) and > deleted after each processing period. > > Over a period of time selecting on the temp table becomes very slow. > > Is this normal?. > or > should we use update statistics on the temp table ? > > NB : The temp table does not have an index and has 3 fields with one > field as date > and will have not more than 200 rec / processing period. > > Jay It all depends on how the temp dbspaces are laid out on disk. Do you have more than one tempdbs? Are they on more than one disk? Remember that OnLine sends out one scan thread per dbspace, if all your temp space is on one tempdbspace, you'll have performance problems. Some queries also require the use of /tmp along with the temp dbspaces. Check the I/O on the disk mounting /tmp. Another thing you might want to check is if the I/O bottleneck is on other tables referred to in the query along with the temp tables. Good luck. Arun