|
|
|
|
|
|
by th3iedkid
3972 days ago
|
|
|
>>Unfortunately, optimizer doesn’t understand, that there’re humans who are building these systems, and humans have their own rationale and thinking. One of the ideas that a human would have is that if you have 100GB table, you better understand things like data locality and other sorts of efficiencies. I have not used MySql and cannot comment for that but with my experience with Oracle, i believe its histogram generation process is actually trying to solve the same problem.It has a binning strategy for histogram generation that tries to help with data patterns. http://docs.oracle.com/database/121/TGSQL/tgsql_histo.htm |
|
|