300 partitions probably isn't a huge number of partitions. But certainly less is generally better. I tend to believe the documentation takes a very conservative stance here. Having a projection … (View Post)

This is an odd comparison. Loading a NATIVE filetype is a complex endeavor, and would result in a very fast load, though the amount of work required to get it into that format might be cumbersome. I&… (View Post)

Sounds like more of a process problem than a technical one. :) In general, I would suggest that having multiple projections isn't really an issue, especially if the table is small. Lots of proje… (View Post)

There's nothing configurable that would control how many projections get created. Are you finding yourself in a position where people are creating a lot of projections? Can you elaborate a littl… (View Post)

What is TF_NAME? And it's also not clear to me what you would need a MIN() around a DECODE()? Try removing the MIN(). Can you share a snippet of the actual table data, and an example output of w… (View Post)