Login
Remember
Register
User rajeshsharma
Wall
Recent activity
All questions
All answers
Ask a Question
Questions by rajeshsharma
0
votes
1
answer
How do you deal with historical data, with respect to zone maps?
asked
Feb 20, 2023
in
Netezza
zone-maps
netezza
+1
vote
1
answer
What is a zone map?
asked
Feb 20, 2023
in
Netezza
zone-map
netezza
+1
vote
1
answer
Explain FPGA and how is it useful for query performance?
asked
Feb 20, 2023
in
Netezza
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
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
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
table-stats
neteza
0
votes
1
answer
Which log file captures SQL submitted to the NPS system?
asked
Feb 20, 2023
in
Netezza
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
reclaim
0
votes
1
answer
What should be considered when you are asked to select the distribution key columns for a very large fact table?
asked
Feb 19, 2023
in
Netezza
netezza-coloumn
+1
vote
1
answer
What is the maximum number of columns you can choose as organizing keys for a clustered base table?
asked
Feb 19, 2023
in
Netezza
netezza
0
votes
1
answer
Which statement is true for database users and groups?
asked
Feb 19, 2023
in
Netezza
database-users
0
votes
1
answer
Which CREATE DATABASE attributes are required?
asked
Feb 19, 2023
in
Netezza
netezza
database
0
votes
1
answer
Which two characteristics describe the materialized view?(Choose two.)
asked
Feb 19, 2023
in
Netezza
netezza
materialized-view
0
votes
1
answer
How Netezza updates a row in a table?
asked
Feb 19, 2023
in
Netezza
netezza-update
0
votes
1
answer
What are the different ways to load data from a file into a table?
asked
Feb 19, 2023
in
Netezza
file-table
+1
vote
1
answer
What are the ways to load data from a table into a file?
asked
Feb 19, 2023
in
Netezza
netezza
table
0
votes
1
answer
What is nzload?
asked
Feb 19, 2023
in
Netezza
nzload
netezza
0
votes
1
answer
How do you remove logically deleted records?
asked
Feb 19, 2023
in
Netezza
netezza
0
votes
1
answer
When Netezza redistributes a table and when it broadcasts a table?
asked
Feb 19, 2023
in
Netezza
netezza
0
votes
1
answer
What is a collocated join?
asked
Feb 19, 2023
in
Netezza
collocated-join
+1
vote
1
answer
How do you check the rows in a table are equally distributed in all SPU’s or not?
asked
Feb 19, 2023
in
Netezza
spu
netezza
0
votes
1
answer
If you did not specify any distribution clause, how the Create Table AS (CTAS) will distribute the rows?
asked
Feb 19, 2023
in
Netezza
netezza
ctas
+1
vote
1
answer
How do you redistribute a table?
asked
Feb 19, 2023
in
Netezza
netezza
+1
vote
1
answer
What data types are most suited for the columns specified in the distribution clause?
asked
Feb 18, 2023
in
Netezza
netezza
distribution-clause
+1
vote
1
answer
Can you update the columns used in the distribution clause?
asked
Feb 18, 2023
in
Netezza
netezza
0
votes
1
answer
If you did not specify any distribution on clause while creating a table, what distribution Netezza uses?
asked
Feb 18, 2023
in
Netezza
netezz
0
votes
1
answer
Up to how many columns you can specify in distributing on clause?
asked
Feb 18, 2023
in
Netezza
distribution-column
+1
vote
1
answer
What are the partitioning methods available in Netezza?
asked
Feb 18, 2023
in
Netezza
netezza
partitioning-methods
0
votes
1
answer
What are the best practices of creating materialized views?
asked
Feb 18, 2023
in
Netezza
netezza
0
votes
1
answer
What are the limitations of materialized views?
asked
Feb 18, 2023
in
Netezza
netezza
Page:
« prev
1
...
39
40
41
42
43
44
45
46
47
48
49
...
187
next »
...