Wednesday, February 1, 2012

No partitions allowed?

Hi, I was surprised to get an error saying that the --skip-partition option is enabled, so my ddl failed since all of my tables have carefully designed partitioning schemes for scalability and performance (every one of my search queries must take advantage of partition pruning).  There is no mention of PARTITION clauses being disallowed in the list of unsupported functions.

I really, REALLY hope this is something temporary and that you can enable it soon.  Without partitioning there is no way the search index I am using the SQL instance for is going to scale along with the rest of my app.


No comments:

Post a Comment