Post reply

what is importanct of views

  • November 24, 2010 at 2:40 am

    #229049

    i need to get counts by using group by from different tables ..for that i wanna going to views..can i using views for fast performance. i wanna know what are disadvantages of views and what is the best scenarios to use views

  • November 24, 2010 at 3:55 am

    #1254974

    Hi,

    An indexed (materialized) view would solve the performance issue. If the base tables are very frequently updated there can be an issue as the view update puts extra load on the server.

    So the behavior of the application is quite important here.

    Cheers and good luck

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply