Re: Two indexes same columns

From: <MHately_at_etech-uk.com>
Date: Fri, 29 Jun 2001 08:23:06 -0700
Message-ID: <F001.0033D90D.20010629075750@fatcity.com>

No, there would be no benefit and it probably wouldn't be allowed anyway unless you reversed the columns in the 2nd index.

Regards,
Mike Hately.

|--------+----------------------->


|        |          Connie       |

|        |          Milliken     |

|        |          <cemail_at_sprin|

|        |          tmail.com>   |

|        |                       |

|        |          06/29/01     |

|        |          04:46 PM     |

|        |          Please       |

|        |          respond to   |

|        |          ORACLE-L     |

|        |                       |

|--------+----------------------->
  >----------------------------------------------------------|
  |                                                          |
  |       To:     Multiple recipients of list ORACLE-L       |
  |       <ORACLE-L_at_fatcity.com>                             |
  |       cc:     (bcc: Mike Hately/ETECH)                   |
  |       Subject:     Two indexes same columns              |
  >----------------------------------------------------------|

If there is a primary key on a table (which inherently builds an index), is it still necessary for performance to build a seperate index on the same columns as those identified in the primary key or is the index generated by the primary key sufficient?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Connie Milliken
  INET: cemail_at_sprintmail.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: MHately_at_etech-uk.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Jun 29 2001 - 10:23:06 CDT