Search found 3 matches

by me_theonlyone
Fri Jul 05, 2013 2:09 pm
Forum: New to Vertica
Topic: Performance After Creating Views in Vertica
Replies: 3
Views: 8327

Re: Performance After Creating Views in Vertica

Unless your view is a super complicated query with lots of joins on several different tables, it won't be slow.
If your view is a basic

Code: Select all

select column1, column2, ... from tablename 
of a particular set of columns from a table, then you would certainly not see any degradation in performance.
by me_theonlyone
Mon Jun 24, 2013 5:17 pm
Forum: Vertica Performance Tuning
Topic: Finding projection definitions
Replies: 6
Views: 19804

Re: Finding projection definitions

When I use this function on one of my views I get the following error: db_mgr=> select export_objects('', 'db_calc.agg_constituent_beta'); INTERNAL 5445: VIAssert(origSize > viewsToDependents.size()) failed DETAIL: /scratch_a/release/vbuild/vertica/DBDesigner/ExportCatalog.cpp: 977 HINT: Please repo...
by me_theonlyone
Fri Jun 21, 2013 5:02 pm
Forum: New to Vertica SQL
Topic: Retrieve Vertica Version from SQL
Replies: 1
Views: 5699

Retrieve Vertica Version from SQL

I was wondering if it was possible to retrieve the Vertica version through some SQL statement. I know this might seem like a stupid question. but I was just wondering if there was a system table with information related to version. I have posted this question to Stackoverflow: http://stackoverflow.c...

Go to advanced search