in reply to Re: Hash lookups, Database lookups, and Scalability
in thread Hash lookups, Database lookups, and Scalability
Also, if the table has a clustered index (Sybase/SQL Server) or the table is index organized (Oracle) or somesuch, there is no extra disk IO to read the row data.
(From your description with 2 physical reads, it sounds like you used a clustered PK index.)
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: Hash lookups, Database lookups, and Scalability
by mpeppler (Vicar) on Oct 31, 2004 at 15:53 UTC | |
by davido (Cardinal) on Oct 31, 2004 at 16:00 UTC | |
by mpeppler (Vicar) on Oct 31, 2004 at 16:19 UTC |
In Section
Meditations