Defining tables for grid queries
Define the tables that you want to include in grid queries as grid tables.
Before you begin
The only prerequisite for defining a table as a grid table is that the table must have the same name, column names, and data types on multiple grid servers. However, the GRID clause has other restrictions and requirements for running grid queries.
About this task
Procedure
Example
cdr change gridtable -–grid=grid1 -–database=stores_demo -–add items orders customer
What to do next
If you want to alter a grid table, you must run the alter operation through the grid. You cannot run a grid query on the table during an alter operation. After the alter operation is complete, the database server verifies that the table is consistent across grid servers.