Search found 2 matches
- Thu Oct 11, 2018 9:52 pm
- Forum: Vertica Links
- Topic: Flattened Tables - Vertica Blog Post
- Replies: 2
- Views: 18335
Re: Flattened Tables - Vertica Blog Post
Bellow is the post I made on other discussion, with my problem with more details: Hello, Ben_Vandiver! I'm having a similar problem here. I have a fact table with millions of registers with some dimensions. And I need to improve a performance of a query, initially I was trying to create a projection...
- Thu Oct 11, 2018 9:52 pm
- Forum: Vertica Links
- Topic: Flattened Tables - Vertica Blog Post
- Replies: 2
- Views: 18335
Re: Flattened Tables - Vertica Blog Post
was asking in a other discussion but since there is no discussion focused on Prejoin Projection and the replacement for this since v8.1 Flattened Tables, I created this one. Basically, what is the best practice to improve the performance of a query with joins in the V9.X? Before V8.1, we would creat...