Indexes represent an alternative way of retrieving table rows. Normally you retrieve table rows using the row's primary key. By creating an index, you can retrieve rows with dissimilar primary key values, but which share some other characteristic.

Indexes can be created on any field which is an indexable datatype, including primary key fields. See Indexable Field Types for information on the types of fields that can be indexed.

For example, if you had a table representing types of automobiles, the primary keys for each row might be the automobile's manufacturer and model type. However, if you wanted to be able to query for all automobiles that are painted red, regardless of the manufacturer or model type, you could create an index on the table's field that contains color information.

CREATE TABLE myInventory.itemDetails (
    itemSKU STRING,
    itemDescription STRING,
    price FLOAT,
    inventoryCount INTEGER,
    PRIMARY KEY (itemSKU)
) 

To create an index, use the CREATE INDEX statement. See CREATE INDEX for details. For example:

CREATE INDEX inventoryIdx on myInventory.itemDetails(inventoryCount)

Similarly, to remove an index, use the DROP INDEX statement. See DROP INDEX for details.

DROP INDEX inventoryIdx on myInventory.itemDetails

Be aware that adding and dropping indexes can take a long time. You might therefore want to run these operations asynchronously using the Store.executeFuture() method.

...
// Store handle configuration and open skipped for brevity
...

store.on('open', function () {
    console.log('Store opened');

    store.executeFuture('CREATE INDEX inventoryIdx on ' +
                  'myInventory.itemDetails(inventoryCount)',
      function(err){
        if (err)
          throw err;
        else {
           console.log('Index creation succeeded.');
           store.close();
        }
      });
    }).on('close', function() {
        console.log('Store closed.');
    }).on('error', function(error) {
        console.log(error);
    });
store.open();