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....