Oracle Index - How To Create a Table Index
Interview Question Database For Software Developers
|
|
| How To Create a Table Index | | How To Create a Table Index? - Oracle DBA FAQ - Managing Oracle Table Indexes | | By: 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.
| | ID: 639 | Rank: 1062 | Votes: 0 | Views: 25 | Submitted: 20070502 |
1062
:-) | | What Is a Table Index | | What Is a Table Index? - Oracle DBA FAQ - Managing Oracle Table Indexes... | | Submitted: 20070502 |
|
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view