{{theTime}}

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:

Could not find method signingConfigs() for arguments

Could not find method signingConfigs() for arguments [build_5dw7nwfc8ibd8sagvx4p79x1u$_run_closure5@13e86039] on root project 'android&#...