Help with Index
Hello,
I have a problem with a query (it's not mine), and i'm not a DBA, i try to create a index, but unsuccessfully, the query cannot run.
How i can create a index to provide better performance?
The query:
select min(clock) as clock from database.table where objectid = t.objectid and clock > t.clock and value = 0 limit 1),unix_timestamp(now())) as clock_up
This is not entire query, it's the part is affecting the query to run, when i comment this part, the query go faster.
I need to create a index to otimize this part.
Server data.
Server version: 5.5.49-37.9 Percona Server (GPL), Release 37.9, Revision efa0073
Thanks so much for help.
Subject
Written By
Posted
Help with Index
August 02, 2016 08:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.