Login
Remember
Register
Ask a Question
Recent questions in Netezza
0
votes
1
answer
What feature in Netezza you do not like?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza-feature
0
votes
1
answer
What data type works best for zone maps?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
zone-maps
0
votes
1
answer
Can we update all columns in a Netezza table?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza-table
0
votes
1
answer
When no distribution clause is used while creating a table, what distribution is used by Netezza?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
distribution-clause
0
votes
1
answer
Why do you prefer to truncate instead of drop table command?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
0
votes
1
answer
Create Table AS (CTAS), does it distribute data randomly or based on the table on which it received data?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
ctas
0
votes
1
answer
Why NOT NULL specification is better in Netezza?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
0
votes
1
answer
What constraints on a table are enforced?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza
0
votes
1
answer
Do we need to drop all tables and objects in that database, before dropping a database?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
database-drop
0
votes
1
answer
What permission will you give to connect to a database?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza-database
0
votes
1
answer
How can we give global permission to user joe so that he can create a table in any database?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza-permission
0
votes
1
answer
Can a group become a member of another group in Netezza user administration. Can we use the same group name for databases?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
user-administration
netezza
0
votes
1
answer
What happens to records that are loaded during nzload process, but were not committed?
asked
Feb 21, 2023
in
Netezza
by
Robindeniel
netezza-records
0
votes
1
answer
How Netezza updates records. Give an idea of how transactions are maintained and how to read consistency is maintained?
asked
Feb 21, 2023
in
Netezza
by
kamalkhandelwal29
netezza-update
0
votes
1
answer
Does Netezza support the concurrent update of the same record?
asked
Feb 21, 2023
in
Netezza
by
kamalkhandelwal29
netezza
0
votes
1
answer
What are 4 environment variables that are required. What are the different states on Netezza?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza-environment
0
votes
1
answer
Explain how data gets stored in Netezza and how does SPU failover takes place?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza
+1
vote
1
answer
When are we likely to receive incorrect (aggregate) results?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
1
answer
How is load achieved in Netezza and why is that quick/fast?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza-load
0
votes
1
answer
What is the best data appliance?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza
appliance
0
votes
1
answer
Does everything get cached in Netezza (or any other data appliance)?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza-cache
cache
0
votes
1
answer
What are different ways to load?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
load-map
netezza
0
votes
1
answer
How do you deal with historical data, with respect to zone maps?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
zone-maps
netezza
+1
vote
1
answer
What is a zone map?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
zone-map
netezza
+1
vote
1
answer
Explain FPGA and how is it useful for query performance?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
fpga
netezza
+1
vote
1
answer
Which system table could be used to find an object id for any table/view or object in a database?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza
+1
vote
1
answer
Which one of the following pieces of information is maintained in the zone map table to assist the performance of a query?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
netezza
0
votes
1
answer
Which one of the following pieces of information is maintained by Statistics on a table?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
table-stats
neteza
0
votes
1
answer
Which log file captures SQL submitted to the NPS system?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
log-files
netezza
0
votes
1
answer
What is the command to display/monitor the status of a reclaim?
asked
Feb 20, 2023
in
Netezza
by
rajeshsharma
reclaim
Page:
1
2
3
next »
Recent questions in Netezza
...
