Hi All i'm having problems writing a recursive query and i ran out of options that i can think of . The query should join serial numbers in one cell coma delimited to a specific order number . ...
I want to know any disadvantage can occur by doing collect stats on a column that is being widely used in join condition across so many procedures ? (Eg. the column is accessed 300+ times access in 60 ...
Viewpoint Guide suggests that there's a daily postgresql backup in my /data/backup folder, each database in every folder ( cam dcsdb lportal td_portal td_portlets ) but in the dcsdb folder there's ...
I need some statistics regarding the performance of Teradata, something like with a given hardware, given nodes and given AMPs - a table which has thousands of rows can be read in 't' secs. I need ...
Does Teradata have a way to rename a primary key constraint, rather than dropping it and recreating it? I'm using SP_RENAME for SQL Server and ALTER TABLE...RENAME CONSTRAINT for Oracle, but I don't ...
I am designing a table in Teradata with about 30 columns. These columns are going to need to store several time-interval-style values such as Daily, Monthly, Weekly, etc. It is bad design to store ...