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:

Kafka Consumer Parallelism

Kafka Parallel Consumer Options: Key-level parallelism:  Multiple threads process the messages from a single partition in parallel while ma...