Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Indexes in Project Manager Sample App
Message
De
09/03/1999 21:51:58
Dave Nantais
Light speed database solutions
Ontario, Canada
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Titre:
Indexes in Project Manager Sample App
Divers
Thread ID:
00195681
Message ID:
00195681
Vues:
59
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
Fil
Voir

Click here to load this message in the networking platform