Hello, I have a table, which has 50000 records in it, and a VIEW which operates on this table. This view is a union of 4 selects. When I try to view the contents of the VIEW, I'm getting the following error.
Auto Commit: On, SQL Mode: Internal, Isolation Level: Committed General error;-904 POS(1) Space for result tables exhausted. SELECT * FROM "SAPADMIN"."SI_UNAVAILABLEFUND_V" Initially, I had only 100 MB of data volume. I had increased the data volume size to 600 MB. It takes about 30 minutes for the SQL Studio to show this error message, which means It is operating on the query of the VIEW for almost 30 minutes, to provide no result at the end. This is a huge performance drawback. What should be done for this ? P.S : The VIEW just works fine with smaller number of records. Thanks in advaance, Suraj. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
