The methods and systems for database statement execution plan optimization
exploit bind variable data available on the network to build and optimize
an execution plan for the statement. A system for database statement
execution plan optimization comprises a bind variable analyzer, a frame
allocator, and an optimizer, in addition to a parser for parsing and
analyzing the statement, a type checker for type checking the statement,
and a tree builder for building an expression tree.