Performance After Creating Views in Vertica

[varuna.bhat]

Hello,

We are migrating the data from SQL Server to Hp Vertica. When we created the tables in Vertica we have renamed the tables along with their custom column names to more sensible naming conventions. For Example the table PPS_Group has been renamed as DIM_Group (Group is a dimension table). And the coulmn PPS_GroupId has been renamed to GroupId in Vertica.

I would like to know like if we create views in Vertica which consists the same naming convention as PPS_Group and PPS_GroupId, will the performance go down or not .

Because the views will contain the same columns as the respective tables.

Thanks,
Varun

[nnani]

Hi Varuna,

How are you going to use your views ?
It really dosen't affect the performance how you are naming the views.
Can you please elaborate your question.

[me_theonlyone]

Unless your view is a super complicated query with lots of joins on several different tables, it won't be slow.
If your view is a basic

Code: Select all

select column1, column2, ... from tablename 

of a particular set of columns from a table, then you would certainly not see any degradation in performance.

[nnani]

Hello Varuna,

Instead of going for views, you can try creating manual projections with the same query you would have used for views.
This can give you good performance.