Home » SQL & PL/SQL » SQL & PL/SQL » Indexing
Indexing [message #238482] Fri, 18 May 2007 05:29 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

hi,

In emp table is a main table .mechanical dept create index in salary and payroll column,computer science dept create index in
emp id and salary column,other department create indexes in emp table other column. Is possible?Multiple dept create index in same table?

Expecting your replies..


Arun..
Re: Indexing [message #238488 is a reply to message #238482] Fri, 18 May 2007 05:53 Go to previous messageGo to next message
saibal
Messages: 111
Registered: March 2007
Location: India
Senior Member
You can't expect replies, if your question in not clear. Show us the tables and their columns and what you are trying to do on it. What kind of indexes you are trying to create?
Re: Indexing [message #238497 is a reply to message #238482] Fri, 18 May 2007 06:07 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm not really sure what you're trying to ask.

Yes you can have multiple indexes on the same table, as long as no two of them index the same set of rows in the same order.
Re: Indexing [message #238505 is a reply to message #238497] Fri, 18 May 2007 06:40 Go to previous messageGo to next message
caliguardo
Messages: 107
Registered: February 2007
Location: Chennai
Senior Member

Quote:
.mechanical dept create index in salary and payroll column,computer science dept create index in
emp id and salary column,other department create indexes in emp table other column.

"Is possible?Multiple dept create index in same table?"


I don't think you can create multiple indexes for different values of the same column. Nope......,It is not possible.
Re: Indexing [message #238967 is a reply to message #238505] Mon, 21 May 2007 01:33 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
http://www.orafaq.com/forum/fa/596/0/
Arun,
you are really testing the moderators' patience here.


http://www.orafaq.com/forum/fa/448/0/

Closed.

MHE
Previous Topic: Two tables join query.
Next Topic: calling functions
Goto Forum:
  


Current Time: Sun Dec 04 00:42:39 CST 2016

Total time taken to generate the page: 0.07695 seconds