Help !! Index creation

From: Raj Rangarjan <raj_at_cs.clemson.edu>
Date: 1996/03/19
Message-ID: <4imt9v$u9v_at_hubcap.clemson.edu>#1/1


Hi,

        I had two question regarding index creation in oracle and was hoping someone could answer them:

  1. Does it matter what order the indexes are created , if two or more fields in a table are indexed?
  2. Does the order of the fields in the table(ie the order they are specified when the table is created) matter when indexes are created on this field? Any help would be appreciated . Please post your replies here or send them to raj_at_cs.clemson.edu

Thanks

--



-Rajasekaran Rangarajan
-Administrative Progamming Services
-Clemson University
-Ph:(864) 656 0731/ Fax:(864) 656-0122
Received on Tue Mar 19 1996 - 00:00:00 CET

Original text of this message