MySQL Forums
Forum List  »  Newbie

Help with Index
Posted by: Jose Ferronato
Date: August 02, 2016 08:52AM

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.

Options: ReplyQuote


Subject
Written By
Posted
Help with Index
August 02, 2016 08:52AM
August 03, 2016 08:03AM
August 03, 2016 10:24AM
August 03, 2016 01:18PM
August 03, 2016 03:08PM
August 05, 2016 08:08AM
August 08, 2016 08:59AM


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.