Table strcuture Vs. Table plan
1 posts in topic
Flat View  Flat View
TOPIC ACTIONS:
 

Posted By:   Prachi_C
Posted On:   Saturday, October 11, 2003 09:30 PM

Whats the difference in the two

Re: Table strcuture Vs. Table plan

Posted By:   Simon_Ablett  
Posted On:   Monday, October 13, 2003 05:14 AM

A table's structure is its definition i.e. names and types of columns, indices etc. A plan, on the other hand, is used to optimise queries i.e. when you query a database table (or groups of tables) modern database systems collate various statistics and then use them in an attempt to optimise future queries.

Regards.
About | Sitemap | Contact