IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Indexes are just tables....
Post #212,202
by ChrisR
6/22/05 11:24:01 PM
Reply
New Indexes are just tables....
...with the last field being a pointer to the record with the corresponding row in the full table. If the Index has full coverage, the query optimizer can get all the data from the index and never have to look at the full table. The primary reason for efficiency is due to have all the records in near vicinity to each other and in the correct order (as opposed to having to check every record scattered throughout the storage unit).
Post #212,260
by mmoffitt
6/23/05 10:36:27 AM
Reply
New Re: just tables.
Unless they are clustered.
bcnu,
Mikem

It would seem, therefore, that the three human impulses embodied in religion are fear, conceit, and hatred. The purpose of religion, one might say, is to give an air of respectibility to these passions. -- Bertrand Russell
     Indexes and primary keys - redundant? - (tablizer) - (9) - June 22, 2005, 04:43:16 PM EDT
         I can't recall every having an index on the primary key - (jbrabeck) - June 22, 2005, 04:16:09 PM EDT
         As I understand it - (tuberculosis) - (1) - June 22, 2005, 06:57:51 PM EDT
             It's definitely the case with Oracle. -NT - (Meerkat) - June 25, 2005, 09:30:22 AM EDT
         The Primary Key is an Index. - (ChrisR) - June 22, 2005, 07:26:24 PM EDT
         Conceptually no, in practice yes - (JayMehaffey) - (3) - June 22, 2005, 10:40:41 PM EDT
             Relational theory does not address indexes - (tablizer) - (2) - June 22, 2005, 11:10:09 PM EDT
                 Indexes are just tables.... - (ChrisR) - (1) - June 22, 2005, 11:24:01 PM EDT
                     Re: just tables. - (mmoffitt) - June 23, 2005, 10:36:27 AM EDT
         Check the index list. - (static) - June 23, 2005, 01:11:11 AM EDT

We didn't invent the art of wishful thinking... we just market it locally.
36 ms