Snowflake
A collection of 48 issues
Understanding Teradata's SAMPLE Function: Randomly Select Rows and More
What is the Teradata Sample Function?
The SAMPLE function returns a set of randomly selected rows. Here are the characteristics:
* Ask for a sample with an absolute number of rows
* Ask for a sample that contains a certain percentage of the table rows
* Ask for more than one sample at
Hot Standby Nodes: The Secret to Seamless Performance and Recovery
A hot standby node belongs to a clique of nodes and does not host virtual processes such as AMPs or Parsing Engines.
The standby node remains idle until a member of its clique crashes or fails. At this point, the standby node is activated to take over the failed node&
Extracting Numeric Tokens from Strings with CHAR2HEXINT Function in Teradata SQL
Learn how the CHAR2HEXINT function helped solve a real-world problem of extracting number parts from a string in Teradata SQL. Read on for the solution.
Variable Declarations in Teradata Stored Procedures
Learn how variable declarations work in a Teradata Stored Procedure. Declarations are always local to the surrounding compound statement. See examples.
Teradata Join Optimization: Early and Partial GROUP BY Techniques for Decision Support Workload
Learn how Teradata applies two effective join optimization methods, Early and Partial GROUP BY, for decision support workloads with lots of aggregations. These transformations reduce resource usage and are widely used in modern databases. Discover how to improve the optimizer's chance to apply these
Boosting Teradata Statistics Performance with New Syntax in Release 14.00
Discover the improvements for Teradata statistics with the new syntax starting from Release 14.00. Learn how to optimize performance and usage.
Understanding MaxValueLength and Its Importance in Teradata Statistics
Learn about Teradata's MaxValueLength feature, which allows users to specify how many bytes or characters should be used when creating statistics histograms.
Optimizing Teradata Queries: A Case Study on Generating Rows Between Start and End Dates
Learn how to optimize SQL queries in Teradata with this case study. See how a recursive query was replaced with a more efficient approach.
Teradata vs. Snowflake: Differences in Architecture
Discover the key architectural differences between Teradata and Snowflake in this informative article. Learn about data distribution, scalability, indexes, workload management, SQL tuning, and more. Read on to find out if Snowflake could be the right fit for your data needs.