Search found 2 matches
- 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'...
- 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...