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
Performance After Creating Views in Vertica
Moderator: NorbertKrupa
-
- Newbie
- Posts: 5
- Joined: Fri May 31, 2013 9:15 pm
Re: Performance After Creating Views in Vertica
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.
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.
-
- Newbie
- Posts: 3
- Joined: Fri May 31, 2013 9:24 am
Re: Performance After Creating Views in Vertica
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 basicof a particular set of columns from a table, then you would certainly not see any degradation in performance.
If your view is a basic
Code: Select all
select column1, column2, ... from tablename
Re: Performance After Creating Views in Vertica
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.
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.