Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: vertica

Revoke access to selected system tables

By adminPosted on May 11, 2023

Question : In Vertica, the SELECT privilege on all system tables in V_CATALOG and V_MONITOR is granted to PUBLIC. Therefore, […]

Vertica performance on select from view with union

By adminPosted on June 1, 2022

Question : We have a huge number of rows(tens of millions), and for each table we have an associated view […]

Vertica performance on select from view with union

By adminPosted on August 24, 2021

Question : We have a huge number of rows(tens of millions), and for each table we have an associated view […]

How To dump data from Oracle to Vertica

By adminPosted on January 11, 2021

Question : I want to transfer data from Oracle to Vertica and I want to know what is best way […]

Set Default Maximum Rows for Export

By adminPosted on July 6, 2020

Question : I am more of a Vertica database user than admin, so I’m not even sure if what I’m […]

Recent Posts

  • Table corruption: How to perform Innodb Checksum checks in MySQL 5.5 for Windows?
  • Create a user on database A with a procedure from database B (with EXECUTE AS)
  • Mysql pivot rows
  • SQL Server CLR procedures and SQLCLR_QUANTUM_PUNISHMENT
  • backup history using availability groups
  • How to prevent database shrinking
  • postgres select aggregate timespans
  • mysql simple update with 40 million and 128GB RAM taking too much time
  • Suggestion for enforcing unique constraint in a table where soft delete is implemented [duplicate]
  • Implementing something similar to “pointer arrays” with MySQL
  • What are valid connection strings for SSMS login box?
  • ERROR 1114 (HY000) at line 6308 in file & The table user_analysis is full
  • Faulty oracle11g regexp_replace on removing duplicates
  • MySQL – Can I have quick queries in a table with 200 million rows?
  • Automatic index creation for primary vs. foreign keys in Postgresql
  • In PostgreSQL, how do I make it so that either column A or column B must be non-null?
  • Automate backup using Windows Task Scheduler
  • Naming Convention for Login, User and Roles? [closed]
  • Changing from utf8 to utf8mb4
  • How to get a COUNT for both IN and NOT IN a table

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding