Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


Post subject: Partition Pruning and parametrized query

registered: 03/08/2013

IP: *.42.54.159

views: 1

hi guys,


Partition pruning section says:

In versions lower than CUBRID 9.0, partition pruning has been executed at the query compiling stage. However, in version of CUBRID 9.0 or higher, it is executed at the server side at the query execution stage

 Does this mean we can not benefit partition pruning when using parametrized query because at compile time arguments are not available?


# Post subject:Re: Partition Pruning and parametrized query


registered: 06/08/2011

IP: *.127.155.139

Prior to CUBRID 9.0, partition pruning could not be performed on a parameterized query. This is because the actual values were not known during compile time. CUBRID 9.0 executes partition pruning during execution. Parameters are known at that time (and also alot of other stuff) so pruning is performed on parameterized queries. For CUBRID 8.4.x and older, the recomandation is to always specify a value search for the partitioning key.


You are either using a very old browser or a browser that is not supported.
In order to browse you need to have one of the following browsers:

Internet Explorer: Mozilla Firefox: Google Chrome: