My Oracle Support Banner

MySQL Server Option: optimizer_search_depth (Doc ID 1335062.1)

Last updated on MARCH 08, 2020

Applies to:

MySQL Server - Version 5.0 and later
Information in this document applies to any platform.


Understand the use of optimizer_search_depth and the problems that can be solved by changing the value.


General discussion for DBA's and developers who are looking at using the option to improve performance.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Where is optimizer_search_depth documented?
 What Does the optimizer_search_depth Option Do?
 What are the Allowed Values?
 What are the Special Features of Values 0 and 63?
 What are the Limitations and Issues when Using optimizer_search_depth = 0?
 What is the Formula Used when optimizer_search_depth = 0?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.