Hi,

Is there a way to find out when a schem was created?

Thanks!

Hi, I provided several queries to DBD to optimize. What is the meaning of the numbers reported by DBD? For example, my output shows: Query 1 optimization ratio or status is 1 Query 2 optimization ratio or status is 1 Query 3 optimization ratio or status is 1.02 Query 4 optimization ratio or status i...

Hello,

I have a huge table that has a column with a high cardinality, but it also has many (1 million +) NULL values.

Does anyone know if there is a performance hit if I would segment on a column like that, i.e., where there a many NULLs? Do all of the NULLs go to one node?

Thanks!

#norbertk,

Thanks for your response! That's what I figured

Hi, Does anyone know what the following events from the query_events table are in detail? Is there anywhere in the documentation that explains them fully? Which ones are bad, good, ok :?: :?: :?: vertica=> select distinct event_type, event_description from query_events order by 1, 2; event_type | ev...

Hi all, I've found a lot of info in the admin guide that explains how to set up the ordering of columns in a projection, but not too much info about what columns to segment on. It it best just to segment by the primary key or the column with the highest cardinality? I think that is correct.... But i...

Howdy,

How can I move a sequence from one schema to another without dropping and re-creating it?

Thanks!