Collections:
CREATE INDEX - Create a Table Index in Oracle
How To Create a Table Index in Oracle?
✍: FYIcenter.com
If you have a table with a lots of rows, and you know that one of the columns will be used often a search criteria, you can add an index for that column to in improve the search performance. To add an index, you can use the CREATE INDEX statement as shown in the following script:
CREATE TABLE tip (id NUMBER(5) PRIMARY KEY, subject VARCHAR(80) NOT NULL, description VARCHAR(256) NOT NULL, create_date DATE DEFAULT (sysdate)); Table created. CREATE INDEX tip_subject ON tip(subject); Index created.
⇒ ALTER INDEX - Rename an Index in Oracle
⇐ DROP TABLE Statement in Oracle
2020-02-20, 6052🔥, 0💬
Popular Posts:
How To Select All Columns of All Rows from a Table in Oracle? The simplest query statement is the on...
How To Concatenate Two Binary Strings Together in SQL Server Transact-SQL? SQL Server 2005 allows to...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How To Get Help Information from the Server in MySQL? While you are at the "mysql>" prompt, y...
How to check if two JSON values have overlaps using the JSON_OVERLAPS() function? JSON_OVERLAPS(json...