Explain a Query Execution Plan

Prepends EXPLAIN to any SELECT to show the query execution plan. Key columns: type (ALL = full scan), rows, Extra (Using index = good).

Variables

Command


        

    







    3 views
    2 copies
    





    
    Log in to rate




    

        
Related in this category

        

                                                
                        Install MariaDB server
                    
                                                                
                        MariaDB secure installation
                    
                                                                
                        Create MariaDB database, user, and grants
                    
                                                                
                        Backup MariaDB database to .sql file
                    
                                    

    





        

        
            
                
            
            Log in to save
        
        
Free account — save snippets into your own collections.