Indexing Practice

CREATE TABLE kaiser
(name VARCHAR(20),
roll NUMBER,
entry_date DATE,
sl NUMBER
)

CREATE TABLE INDEX kaiserkk


CREATE INDEX kaiserkk ON kaiser
(roll)
NOLOGGING
TABLESPACE USERS
NOPARALLEL;



CREATE INDEX ord_customer_ix_demo
 ON kaiser (roll)


 SELECT *FROM kaiser
 WHERE roll>0