SQL Statements

When running multiple sql statements as part of the same statement, it is possible that the execution is not as you might expect. For example:

create index i1 on t1 (a); update t1 set b = 5 where a = 6;

In the above instance, the index is created and the update is executed as part of the same statement. At the time that this update is compiled, the index will not yet exist and therefore will not be used.

Statement Reference

NuoDB supports the following SQL statements:

MAP PARTITION is deprecated in NuoDB 5.1.