Search This Blog

Total Pageviews

Creating Indexes

Creating an Index Explicitly

You can create indexes explicitly (outside of integrity constraints) using the SQL statement CREATE INDEX. The following statement creates an index named emp_ename for the ename column of the emp table:

CREATE INDEX emp_ename ON emp(ename)       TABLESPACE users       STORAGE (INITIAL 20K       NEXT 20k       PCTINCREASE 75);
Find more tutorials here. Creating Indexes

No comments:

Windows 8.3 file naming setting is disabled for the product

To enable Windows 8.3 file naming setting use fsutil command Example:  c:\> fsutil 8dot3name set C: 0