Create and delete an index on oracle table columns

Suppose we have the following table, and we often execute queries to display the bookmarks belonging to a certain category: CREATE TABLE bookmark ( id NUMBER(10, 0), -- number 10 digits before the decimal and 0 digits after the decimal title VARCHAR2(255 CHAR) NOT NULL, -- String with a maximum length of 255 charachters url VARCHAR2(500 CHAR) UNIQUE NOT NULL, -- holds unique values across the table data category VARCHAR2(500 CHAR) NOT NULL, -- holds ...

Submit