Oracle - Index creation

Create indexes on a table to optimize data queries, always when the query is made using the indexed field

CREATE INDEX <index_name> on <table_name>(<table_field_name>);

Comments

Popular posts from this blog

Oracle - duplicate fields in RECORD,TABLE or argument list are not permitted

Oracle - ORA-29282: invalid file ID, ORA-06512: at "SYS.UTL_FILE"