Create Index in Oracle Database Example

How to Create Index in Oracle Database Tutorial Example

Run Query Editor then copy & paste the below create index on a column of a table in Oracle Database Server Tutorial Example

   -- CONNECT AS Any User or HR
   -- Syntax : CREATE INDEX  index_name ON table_name(column_name) SORT/NOSORT LOGGING/NOLOGGING

   CREATE INDEX  IDX_EMPLOYEE
   ON            EMPLOYEES(LAST_NAME)
   NOLOGGING;
      -- is comment in Oracle
      -- in fact it is comment in MSSQL and MySQL as well
   

How to Create Index in Oracle Database Tutorial Example - Result in Query Editor Client Tools

No comments:

Post a Comment

leave your comments here..