Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexes in Project Manager Sample App
Message
From
09/03/1999 21:51:58
Dave Nantais
Light speed database solutions
Ontario, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
Indexes in Project Manager Sample App
Miscellaneous
Thread ID:
00195681
Message ID:
00195681
Views:
51
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.
Next
Reply
Map
View

Click here to load this message in the networking platform