Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Data structure for indexing on multiple keys.

Data structure for indexing on multiple keys.

From: Shankar <shankar_at_xyz.com>
Date: Wed, 08 Sep 2004 18:15:34 +0530
Message-ID: <X7D%c.57$sk2.87@news.oracle.com> 





Hi,



    I have fair knowledge of B-tree and hash indexing mechanisms. What 
data structure/algorithms should I read upon if I want to create indexes 
on multiple keys of a same relation? For e.g if a Employee relation has 
EmpNo, EmpName, EmpSalary, EmpDepth attributes & users can query on any 
of these attributes. Do I create separate B-trees for each key?



    Please note that this is not about composite keys but supporting 
multiple keys for searching. Thanks in advance for inputs!



Regards,


Shankar
Received on Wed Sep 08 2004 - 07:45:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US