What occurs more, updates? Or views (SELECT)?

About 75% more updates and 25% select
thanks

In my personal experience I have always found indexes to be beneficial. The basic premise of storing data is that sooner or later you want to view that information, and view it in certain subsets or in a certain sort order. The bottom line is, you'll likely want that data indexed.

Can one make an argument for not requiring an index? Certainly! Especially if you are reading the data sequentially as opposed to seeking. I'm not certain where in the MySQL docs you read the statement you refer to in your first post but the manual page on Optimizing SELECT and Other Statements [dev.mysql.com] leads you more toward using indexes as opposed to leaving them out of your development.

Thank you
I will read more and very probably will "index"
anyway before final release I will have a few hundreds testers trying to put it to its knees!
So I might test both modes.