MySQL Forums :: Partitioning :: query optimization


Advanced Search

Re: query optimization
Posted by: Rick James ()
Date: October 30, 2015 04:58PM

    where  p.host_name in (
        SELECT  node_name
            from  oam_db.node
            where  cluster_name='AIRTEL_TANZANIA_MOBIQUITY' 
                           )
--> (to avoid the poor performance of "IN ( SELECT ...)")
    JOIN   oam_db.node AS n
        ON n.node_name = p.host_name
    where  n.cluster_name='AIRTEL_TANZANIA_MOBIQUITY'

Avoid leading '%' when possible

INDEX(timestamp)

INDEX(cluster_name, node_name)

There may be more suggestions. If these suggestions do not suffice, please provide SHOW CREATE TABLE.

Options: ReplyQuote


Subject Views Written By Posted
query optimization 1078 Srilakshmi Manjunath 10/29/2015 03:08AM
Re: query optimization 601 Rick James 10/30/2015 04:58PM


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.