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:

FastAPI throws an error (Error loading ASGI app. Could not import module "main")

Make sure the main fastapi code is in the same directory where you are running the code.