Em 5/9/2013 13:18, jym...@gmail.com escreveu:
Thanks, I will try use GLOBAL TEMPORARY and INACTIVE index.
The insert time will be faster without the index, but you will spend a lot of time when you reactivate it... And any query that will run during the insert time will not use the indice, so, it will be very slow to do a full table scan in a multi million record table....
Take into account that you will reactivate the index 24 times a day....
