0

I have a table in mysql database which contains millions of records. In my application I want to query this table on different column bases. I have created view for this table where all columns exist. I want to know is this the good practice to create multiple views on different column bases ?

Deepak Singh Basnal
  • 61
  • 7
  • view is simply a query... it doesn't take any resources to upkeep/maintain... duplicate of https://stackoverflow.com/questions/40169/is-it-okay-to-have-a-lot-of-database-views – Aleksei Maide Feb 19 '18 at 06:39
  • Possible duplicate of [Is it okay to have a lot of database views?](https://stackoverflow.com/questions/40169/is-it-okay-to-have-a-lot-of-database-views) – Aleksei Maide Feb 19 '18 at 06:40

1 Answers1

0

The only problem for the perfomance is how mysql handle views.

Here is a good anwser from Derek Downey: on dba stackexchnage

Daniel E.
  • 2,440
  • 1
  • 14
  • 24