MySQL High Availability by Charles Bell;Mats Kindahl;Lars Thalmann
Author:Charles Bell;Mats Kindahl;Lars Thalmann
Format: mobi
Tags: COMPUTERS / Database Management / General
Publisher: O'Reilly Media
Published: 2010-06-27T23:00:00+00:00
Using ANALYZE TABLE
The MySQL optimizer, like most traditional optimizers, uses statistical information about tables to perform its analysis of the optimal query execution plan. These statistics include information about indexes, distribution of values, and table structure, among many items.
The ANALYZE TABLE command recalculates the key distribution for one or more tables. This information determines the table order for a join operation. The syntax for the ANALYZE TABLE command is shown below:
ANALYZE [LOCAL | NO_WRITE_TO_BINLOG] TABLE <table_list>
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Sass and Compass in Action by Wynn Netherland Nathan Weizenbaum Chris Eppstein Brandon Mathis(7745)
Grails in Action by Glen Smith Peter Ledbrook(7667)
Configuring Windows Server Hybrid Advanced Services Exam Ref AZ-801 by Chris Gill(6245)
Azure Containers Explained by Wesley Haakman & Richard Hooper(6205)
Running Windows Containers on AWS by Marcio Morales(5728)
Kotlin in Action by Dmitry Jemerov(5019)
Microsoft 365 Identity and Services Exam Guide MS-100 by Aaron Guilmette(4737)
Management Strategies for the Cloud Revolution: How Cloud Computing Is Transforming Business and Why You Can't Afford to Be Left Behind by Charles Babcock(4396)
Combating Crime on the Dark Web by Nearchos Nearchou(4326)
Microsoft Cybersecurity Architect Exam Ref SC-100 by Dwayne Natwick(3997)
The Ruby Workshop by Akshat Paul Peter Philips Dániel Szabó and Cheyne Wallace(3989)
The Age of Surveillance Capitalism by Shoshana Zuboff(3914)
Python for Security and Networking - Third Edition by José Manuel Ortega(3549)
Learn Windows PowerShell in a Month of Lunches by Don Jones(3489)
Mastering Python for Networking and Security by José Manuel Ortega(3321)
Mastering Azure Security by Mustafa Toroman and Tom Janetscheck(3311)
Blockchain Basics by Daniel Drescher(3274)
The Ultimate Docker Container Book by Schenker Gabriel N.;(3228)
TCP IP by Todd Lammle(2959)
