| urgent [message #370511] |
Mon, 13 December 1999 01:19  |
Suresh
Messages: 189
Registered: December 1998
|
Senior Member |
|
|
How do you create a btree index in sql
example
create btree index on student(sname);
The above statement does not work..how do we do ??
|
|
|
|
|
|
| Re: urgent [message #370514 is a reply to message #370511] |
Mon, 13 December 1999 11:45  |
Cindy
Messages: 88
Registered: November 1999
|
Member |
|
|
When you execute a create index statement
Oracle automatically creates a B-tree index.
Just use the normal create index syntax, ie.
CREATE INDEX <INDEX_NAME> on ...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
