Laurent Vaills wrote: > 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 ?
Indexes will be automatically updated by the SAP DB kernel but I assume the long runtime is the result of outdated optimizer statistics. You should call the update statistics command for each table after loading data into it. BTW for huge amount of data it may be faster to create the indexes after loading the data but it depends. Best regards, Holger SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
