[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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
