Home › Forum › Software › db-performance › Reply To: db-performance
February 11, 2015 at 10:13 am
#1328
Keymaster
Your SQL query has been executed successfully (Query took 196.2649 sec)
CREATE INDEX idx_db_devid ON uradmonitor(
db_devid
)
I was just creating 7 charts in parallel for some experiment with various tubes. It was hard for the server, but after adding this additional index all 7 were generated instantly!
Speed improvement: amazing!
Thanks