Home » RDBMS Server » Server Administration » urgent
urgent [message #370511] Mon, 13 December 1999 01:19 Go to next message
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 #370512 is a reply to message #370511] Mon, 13 December 1999 01:24 Go to previous messageGo to next message
btree indexing ???
Messages: 1
Registered: December 1999
Junior Member
btree indexing
Re: urgent [message #370514 is a reply to message #370511] Mon, 13 December 1999 11:45 Go to previous message
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 ...
Previous Topic: Using variables instead of constants
Next Topic: OCI & result sets
Goto Forum:
  


Current Time: Thu Mar 28 09:28:08 CDT 2024