by S-Square | Jun 28, 2019 | Blogs
Introduction: In this document, we are going see the flow of query processing and result caching feature in Amazon Redshift. The Query Planning And Execution Workflow: The leader node receives the query and parses the SQL. The parser produces an initial query tree...
by S-Square | Jun 28, 2019 | Blogs
What Is Compression? Compression is a column-level operation that reduces the size of data when it is stored. Compression conserves storage space and reduces the size of data that is read from storage, which reduces the amount of disk I/O and therefore improves query...
by S-Square | Jun 27, 2019 | Blogs
Sometimes Tableau will not recognise one or more of the location names in your data. When this happens, those values are marked as unknown in the lower right corner of the map view. Edit Locations In The Special Values Menu Sometimes, unknown locations can be prompted...
by S-Square | Jun 26, 2019 | Blogs
Introduction: HAProxy, which stands for High Availability Proxy. Its most common use is to improve the performance and reliability of a server environment by distributing the workload across multiple servers. HAProxy is a popular open source software TCP/HTTP Load...
by S-Square | Jun 26, 2019 | Blogs
JOINS: Join is used to combine one or more tables, from tables based on condition (Common fields). Joins are divided into four categories. Inner Join Left Outer Join Right Outer Join Full Outer Join Table A and Table B, with some sort of relation specified by primary...
