Specify the logical sbspace name

The following example creates a virtual index in the previously created vspace1:

CREATE INDEX ix1 ON tab1(col1)
   IN vspace1
   USING your_access_method

If you do not intend to specify an sbspace explicitly in the CREATE INDEX statement, specify a default sbspace.

The following example also creates a virtual index in the sbspace that SBSPACENAME specifies:

CREATE INDEX ix1 ON tab1(col1)
   USING your_access_method