Archive for the ‘MySQL feature’ Category

The battle between FORCE INDEX and the QUERY OPTIMIZER

Октябрь 26th, 2010
Query Optimizer is a part of the server that takes a parsed SQL query and produces a query execution plan. MySQL Query Optimizer uses (as one of its parameters) the stored key distribution (Cardinality) mechanism to determine the order in which tables should be joined, when you perform a join on something other than a [...]
PlanetMySQL Voting: Vote UP / Vote DOWN
 

Posted in Cool MySQL Queries, MySQL feature

Комментарии отключены

 

User Defined Variables

Июнь 3rd, 2010
When I have discovered MySQL User-defined variables at the first time, I didn’t pay much attention to them and didn’t realize their strength. At first, one can think that they are just one of the many unnoticed MySQL features. Well, I was wrong. Here, I will try to summarize their strength, though I think there is [...]
PlanetMySQL Voting: Vote UP / Vote DOWN
 

Posted in case sensitivity, MySQL feature, mysql features, mysql query, procedural logic, relational logic, User defined variable, variables

Комментарии отключены