Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

author
message
[Level:0]majidazimi

Post subject: Partition Pruning and parametrized query

registered: 03/09/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?

Quote
[Level:5]eusto

# Post subject:Re: Partition Pruning and parametrized query

profile

registered: 06/09/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.

Quote




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



Internet Explorer: Mozilla Firefox: Google Chrome: