Recent questions tagged netezza

0 votes

What is nzload?

asked Feb 19, 2023 in Netezza by rajeshsharma

0 votes

How do you remove logically deleted records?

asked Feb 19, 2023 in Netezza by rajeshsharma

0 votes

When Netezza redistributes a table and when it broadcasts a table?

asked Feb 19, 2023 in Netezza by rajeshsharma

+1 vote

How do you check the rows in a table are equally distributed in all SPU’s or not?

asked Feb 19, 2023 in Netezza by rajeshsharma

0 votes

If you did not specify any distribution clause, how the Create Table AS (CTAS) will distribute the rows?

asked Feb 19, 2023 in Netezza by rajeshsharma

+1 vote

How do you redistribute a table?

asked Feb 19, 2023 in Netezza by rajeshsharma

+1 vote

What data types are most suited for the columns specified in the distribution clause?

asked Feb 18, 2023 in Netezza by rajeshsharma

+1 vote

Can you update the columns used in the distribution clause?

asked Feb 18, 2023 in Netezza by rajeshsharma

+1 vote

What are the partitioning methods available in Netezza?

asked Feb 18, 2023 in Netezza by rajeshsharma

0 votes

What are the best practices of creating materialized views?

asked Feb 18, 2023 in Netezza by rajeshsharma

0 votes

What are the limitations of materialized views?

asked Feb 18, 2023 in Netezza by rajeshsharma

0 votes

What is the distribution of materialized views?

asked Feb 18, 2023 in Netezza by rajeshsharma

0 votes

What is generate statistics and generate express statistics OR what is the difference between generate statistics and generate express statistics?

asked Feb 18, 2023 in Netezza by rajeshsharma

0 votes

How the zone maps are created and updated?

asked Feb 18, 2023 in Netezza by rajeshsharma

0 votes

What are zone maps?

asked Feb 18, 2023 in Netezza by rajeshsharma

0 votes

What are the constraints on a table that are enforced?

asked Feb 18, 2023 in Netezza by rajeshsharma

Page:

...