Search code examples
mysqlviewcreate-table

MySQL: view or create a new table?

I'm doing a java project in which I have to use a MySQL database with a big amount of data (geonames). Since I need to verify if a proper name is a geoentity I need only 3 coloums of a table. So I would like to know if it is better to use a view of this table or just create another table with only this three attributes.

Thanks in advance!

Solution

  • There is no need creating a view in the case. If you do this, maybe more overhead on this db.

    BTW, creating proper index will affect a lot performance.