Vertica performance tuning techniques

Moderator: NorbertKrupa

Post Reply
sri2248
Newbie
Newbie
Posts: 2
Joined: Wed Jul 22, 2015 5:13 pm

Vertica performance tuning techniques

Post by sri2248 » 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

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Vertica performance tuning techniques

Post by id10t » Thu Jul 23, 2015 9:16 am

Hi!
sri2248 wrote:How could i create projections using DBD. Please let me know the detailed steps on this.
Surprise 1: Vertica has documentation.
Surprise 2: Internet is full in such kind of info

For what people writes documentation? <=> Why we should to repost/rewrite/reblog it? Why we should waste out time twice for same problem - "describe in details/help me"?
For what people created a search engines? <=> Why you are too lazy to search?

---
Don't be lazy and respect developers that writes documentation/blogs/tutorials for YOU.

Post Reply

Return to “New to Vertica”