Hi all,

Does anyone have any tips or best ways to handle a COUNT DISTINCT on a very large data set (> 1 million rows in a fact table). I'm seeing my queries take > 30 seconds with the COUNT DISTINCT and about 7 seconds with a simple COUNT.

Thanks!

Thanks, guys! Scutter, you said: Idle sessions don’t use any memory It has to consume some memory, right? What about the session meta-data? Like the data (i.e. last_statement) in the sessions table itself. Doesn't that consume memory? If you multiply that small amount of memory usage by 100's of ina...

Hi!

Is there a way to determine the amount of a host's system resources an orphan/zombie session is wasting in the DB? It seems a reporting tool we are using isn;t closing sessions

Hi,

Is it possible to prevent users from connecting to the Vertica DB from certain client tools? For instance, say I don't want any one connecting from MS Excel or query tools like Toad.

Vertica won't let me create more than one PK constraint on a column: dbadmin=> create table s (s1 int not null); CREATE TABLE dbadmin=> alter table s add constraint pk1 primary key (s1); ALTER TABLE dbadmin=> alter table s add constraint pk2 primary key (s1); ROLLBACK 4413: Primary constraint for re...

Oops, sorry, Jim... I should have searched and found that myself Thanks!

Howdy,

Is there an option on the ANALYZE_STATISTICS function that will allow me to analyze all the tables in the schema, or do I have to do each table individually?