Search found 2 matches

by msv
Thu Jan 22, 2015 3:25 am
Forum: New to Vertica Database Development
Topic: Encoding Techniques for table creation
Replies: 3
Views: 21581

Re: Encoding Techniques for table creation

RLE on a rowid doesn't seem very optimal and sticks out like a sore thumb in your example. I think it is important to note that you need real, representative data in these tables before running DBD or related API. Also, DBD can be run without deployment if you just want to look over the scripts. It'...
by msv
Thu Sep 11, 2014 5:32 pm
Forum: New to Vertica Database Administration
Topic: Composite Key vs. Surrogate Key
Replies: 10
Views: 19522

Re: Composite Key vs. Surrogate Key

@sKwa I highly doubt that there is no performance advantage at query time. You may be able to mitigate some of the performance degradation (perhaps grouping fields in the projection, for example) but even still there would be some performance difference in favor of a single integer key join. Be real...

Go to advanced search