Hello. We are currently using the loadercli to migrate a database to SAP DB.
We create the tables and all the indexes as they were defined in the previous database. Then we run the loadercli to insert the values (with the DATALOAD commands) in the defined tables. Everything is ok, we got no error. But it seems that the indexes are not updated : some queries take a very long time (> 1 hour) and end up with "-904,Space for result tables exhausted". Our database is created with 1Gb for the data devspace and is filled with only 14%. We tried to drop and recreate again the indexes and we get the results of the queries in less than 1 minute. After the DATALOAD commands, are there any special commands to execute to update the index ? Why is it not done automatically ? Best regards, Laurent -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
