Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Performance of Views compared to tables

Querying a table is faster or View ? I am creating a view because my table names are not named properly and I cant expose them to my business, so i want to create a business layer with views and having a proper naming of columns and expose those views to Business

Comments

  • Hi Manu, If your view is simple (for example, if you're just renaming columns), then you should see no performance difference between querying the view and querying the underlying table. Vertica will look at the view definition and realize that you really just want to access the underlying the table, and will execute the query accordingly. Adam
  • Thanks for the quick reply Adam..Our Whole team thanks you..

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.