Home » SQL & PL/SQL » SQL & PL/SQL » index on columns
index on columns [message #192243] Mon, 11 September 2006 09:31 Go to next message
miroconnect@yahoo.com
Messages: 202
Registered: April 2006
Senior Member
Index on a cloumn can be created on any kind of columns or only on primary key column or column with unique constraint.

Report message to a moderator

Re: index on columns [message #192245 is a reply to message #192243] Mon, 11 September 2006 09:35 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
When all else fails try reading the fine Concepts Manual found at http://tahiti.oarcle.com

Report message to a moderator

Re: index on columns [message #192317 is a reply to message #192243] Mon, 11 September 2006 16:37 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
An index can be made on ANY column, combination of columns, or even functions on columns.

Report message to a moderator

Re: index on columns [message #192430 is a reply to message #192317] Tue, 12 September 2006 06:24 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Bill B wrote on Tue, 12 September 2006 07:37

An index can be made on ANY column, combination of columns, or even functions on columns.


ANY column? Even LONGs?
Ross Leishman

Report message to a moderator

Re: index on columns [message #192448 is a reply to message #192430] Tue, 12 September 2006 07:42 Go to previous messageGo to next message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
You caught me, of course you can't make an index on blobs or longs,

Report message to a moderator

Re: index on columns [message #192486 is a reply to message #192448] Tue, 12 September 2006 10:08 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
What about text indexes?

Report message to a moderator

Re: index on columns [message #192513 is a reply to message #192243] Tue, 12 September 2006 12:48 Go to previous message
Bill B
Messages: 1971
Registered: December 2004
Senior Member
The CTX indexes are not indexes in the classic case, they are only used when you invoke a clause that uses the ORACLE TEXT engine. They are not automatically maintained like normal indexes and must be updated on a regular schedule.

Report message to a moderator

Previous Topic: Web Service consumption in Oracle
Next Topic: ORA-01847 day of the month must be between 1 and last day of month
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Dec 07 00:16:05 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.