Home Dashboard Directory Help
Search

BUCKET_COUNT should be changeable by Tony Rogerson SQL


Status: 

Active


1
0
Sign in
to vote
Type: Suggestion
ID: 811502
Opened: 12/13/2013 2:07:44 AM
Access Restriction: Public
0
Workaround(s)
view

Description

BUCKET_COUNT is fixed - you CREATE TABLE, it creates the .c file which then is used as your table structure.

Over time as data grows there will be a need to change BUCKET_COUNT.

The only way to do that at the moment is to copy the data out of the in-memory table (BCP or SELECT INTO), drop and recreate the tables (and all the associated native compiled sp's) and reload the data.
Details
Sign in to post a comment.
Sign in to post a workaround.