~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to docs/analyze.rst

• browse files at revision 2030.1.2
• compare with another revision
• download diff
• download tarball
• view history from revision 2030.1.2

• reverse the comparison (2030.1.2 to 2165.1.3)
• stop comparing with revision 2165.1.3

Show diffs side-by-side

added

removed

docs/analyze.rst

1

 

ANALYZE

 

1

ANALYZE 

2

2

=======

3

3

 

4

4

ANALYZE TABLE table_name [, table_name] ...

5

5

 

6

6

ANALYZE TABLE read locks a table, and then analyzes and stores the key distribution for a table.

7

 

 

8

 

FIXME: is read lock always true?

9

 

 

10

 

FIXME: some engines don't perform an explicit gathering of statistics when

11

 

you type ANALYZE. e.g. innobase (which only copies it's current estimate).

12

 

Only recently did I add this to HailDB so that it does go and do the index

13

 

dives on ANALYZE.

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1