Hello, I would like to know what's happening when we execute this command: db_start and db_warm.
This question comes from the following situation: We are trying to do a benchmark and here is the procedure: 1. db_start 2. db_warm 3. execute the query: select count(*) .... -> we get the execution time (for example 4 min.) 4. execute a second time the same query: 56 sec. 5. db_stop 6. db_warm 7. execute the query: select count(*) .... -> we get the execution time 56 sec (again!) I don't know why after a shutdown of the database(db_stop) the query doesn't take the same time than the first time we executed the query?????????????? What does the database during a db_start and b_warm????? Thanks, S�bastien E-mail: [EMAIL PROTECTED] _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
