Question : The following query gives me a list of 1222 distinct columns: select distinct column_name from information_schema.columns where table_name […]
Tag: greenplum
Greenplum add a column to table and insert value to it in incremental order
Question : I have a table st.student like following, which has one column. STUDENT_ID 100001 100002 100003 100004 100005 100006 […]
What is the fastest way copy 800Gb data from Greenplum to MS SQL Server
Question : Our company has a base on Greenplum with a total volume of almost 800 GB. What is the […]
Fetching rows from million rows table(Optimization)
Question : I have millions of rows in a table of Greenplum database out of which I have to fetch […]
Resolve parametrized schema in PostgreSQL
Question : I’m looking for a way to use a parametrized schema in the DECLARE section of a PostgreSQL function. […]
Are sql tuning ways same for different DB engine？ [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
How to retrieve a view column derivation in PostgreSQL or Greenplum
Question : I want to retrieve the derivation expression of a column in a view, and I want to do […]
Are sql tuning ways same for different DB engine？ [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]