Vertica performance tuning techniques
Posted: Thu Jul 23, 2015 2:38 am
Hello everyone,
I was given a work to imrove the performance of Load process.
Load proccess contains combination of INSERT INTO, Delete and Update statements.All these scripts are taken from Teradata and wrote in vsql and are not yet executed on vertica environment. Projections need to be taken care of for these tables. Please let me know the steps which i need to be taken care of for creating projections and improving performance of these sqls.
Performance tuning:
I started with applying DIRECT hints to Insert, Delete, update statements.
Projection creation:
How could i create projections using DBD. Please let me know the detailed steps on this.
Thanks for your understanding.
Thanks,
Sri
I was given a work to imrove the performance of Load process.
Load proccess contains combination of INSERT INTO, Delete and Update statements.All these scripts are taken from Teradata and wrote in vsql and are not yet executed on vertica environment. Projections need to be taken care of for these tables. Please let me know the steps which i need to be taken care of for creating projections and improving performance of these sqls.
Performance tuning:
I started with applying DIRECT hints to Insert, Delete, update statements.
Projection creation:
How could i create projections using DBD. Please let me know the detailed steps on this.
Thanks for your understanding.
Thanks,
Sri