Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by LQS
-
Performance of Informix views
"Is your temp space limited because of physical disk limitations?" Yes I believe we are reaching capacity. But the point is that if the view wasn't materialized before the join to the other table, so much temp space wouldn't be needed. "Have you looked into using the fragment...- LQS
- Post #5
- Forum: Informix solutions
-
Performance of Informix views
Yes we have set explain on and updated statistics. It seems that the view is being completely materialized before it is being joined to the other lookup table. Therefore longer return times and the filling up of temporary disk space. I am not sure there is any way around this... Any thoughts ?- LQS
- Post #3
- Forum: Informix solutions
-
Performance of Informix views
I am looking for some advice on how to speed up response time when creating/using views. I have a view that has many millions of rows which is joined to a smaller table with, say, 12 million rows. A user is using this view by joining the view itself to a couple of small lookup tables, which are...- LQS
- Thread
- Replies: 4
- Forum: Informix solutions
