Hi , Got a problem while dropping a user (created by DBADMIN ) connecting with the user who is having the DBADMIN Role Enabled.!! According to the Administrators guide , i'm having the following privileges to the user , who has DBADMIN Role Enabled. The DBADMIN Role Every database has the special DB...

Hi..

As Oracle is having Snapshot option.. and even the vertica too..


Is Snapshot in oracle and Vertica are same??


Thanks
Raj!!

Hi,

As Oracle is having Flashback Concept,

Do Vertica too have Flashback Concept??

HI,

Can a user lock a table in vertica?

As Oracle having the syntax as follows
Lock table <Table_Name> Exclusive Mode ;

Do Vertica have this kind of facility??

Thanks,
Raj!!

Hi knicely, Thanks a lot for your quick response. I have verified the timing also. By using the analytic function in the query, it is taking lot of time to retrieve the records compared to the normal aggregate function. Nearly it is taking 3 times the aggregate function execution time. Execution tim...

Hi Knicely, Is using analytic function recommended one? Does it reduces the performance of the query? Eg: select Distinct Department , Count(Emp_ID) Over (Partition By Department) as Emp_Count From EMP; Can i use the above query instead of the below one!! Which performs better? Select Count(Emp_ID),...

Hi, I Backed up a schema from one server of vertica version “Vertica Analytic Database v6.0.0-0” and trying to restore it in the another server of vertica version “Vertica Analytic Database v6.0.1-0”. When I was trying to restore the backup(after stopping the Database), it is showing an error like ‘...