Information générale
Catégorie:
The Mere Mortals Framework
Titre:
Indexes in Project Manager Sample App
forgive such a basic question but i am new to the MM way of
handling data ; i am a single tier dinosaur
what are the reasons for placing an index on a view
versus the reasons for placing an index on a table ?
i think that indexes are made on views for keeping the data DISPLAYED in a specific order
whereas
an index on a table in a database is used for these reasons
1. primary id of a table for all sorts of basic housekeeping reasons
2. DELETED() for rushmore optimization
3. allowing relations to exist between TABLES
4. speed up the query portion of a parameterized view done on the table ... if the table is large ..
and i think
this is why one may encounter an index on a table that is identical to an index on a view of that table ?
am i missing anything here ?
TIA, Dave.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement