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.
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: 25042
Registered: January 2009
Location: SoCal
Senior Member
When all else fails try reading the fine Concepts Manual found at http://tahiti.oarcle.com
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: 1484
Registered: December 2004
Senior Member
An index can be made on ANY column, combination of columns, or even functions on columns.
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: 3724
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
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: 1484
Registered: December 2004
Senior Member
You caught me, of course you can't make an index on blobs or longs,
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: 7880
Registered: March 2000
Senior Member
What about text indexes?
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: 1484
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.
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:
  


Current Time: Wed Dec 07 03:09:07 CST 2016

Total time taken to generate the page: 0.18984 seconds