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, 3126🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...