Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> second part of index use
Hi
You have a table with 'n' columns, 2 of which are employeecode and
date. You also have a clustered index on (date, employeecode). You
have a query which looks for an employee with
dates between DateA and DateB.
(1) The query uses the index to get to DateA, how does it then find the employee? Is the date/employee hashed in some way? Does it first find the date then scan to get the employee?
(2) In general does it make more sense to cluster on date then employee or employee then date. I would imagine this depends on the queries that take place. Assume about 50,000 employees and about 3 years of dates (so about 1000 days)
ta Received on Fri Jul 06 2007 - 15:08:22 CDT
![]() |
![]() |