Thanks I overlooked the topic about VIEWS on the MySQL manual, your response was very useful.
Thank you again for your time and response. On 6/9/06, Jay Blanchard <[EMAIL PROTECTED]> wrote:
[snip] I am facing some problems to identify the advantages or disadvantages of the use of INDEXes (a.k.a. VIEWS in other DBMS environments, please correct me if am wrong), this is the scenario: [/snip] index != view AFAIK An index on a column or columns is a method for the database to keep track of and speed access to data that utilizes the index. http://dev.mysql.com/doc/refman/5.0/en/create-index.html A view is a pseudo-table based on a query or set of queries. Consider a query that selects 3 columns from a table that contains 16 columns. You now have a particular 'view' of that table....in the form of a table. http://dev.mysql.com/doc/refman/5.1/en/create-view.html
-- Iván Alemán ~ [[ m o f o ]] ~ Debian (SID) -----BEGIN GEEK CODE BLOCK----- Version: 3.12 G!>GCM d+ s: a? C+++ UL++ P L+>+++$ E--- W++>+ N* o--- K- w O- M+ V-- PS++ PE-- Y PGP+>++ t-- 5 X R+ !tv b++ DI-- D+++ G+ e++ h* r+ z*>*$ ------END GEEK CODE BLOCK------ bonovoxmofo.blogspot.com 6EA4 BC00 420B 2087 C546 32D6 1258 3492 4220 7E8B
