title: What is difference between INDEX and VIEW in MySQL
body: <p>Which one is fast either Index or View both are used for optimization purpose both are implement on table's column so any one explain which one is more faster and what is difference between both of them and which scenario we use view and index. </p>