DSXchange

Hi I am getting the below warning

"StageName": You have specified the query: `Query'
to run in parallel without using the NODENUMBER clause to localize the query;
this may result in extracting multiple copies of the answer set
leading to incorrect results and sub-optimal performance.

In the query where clause i am doing DBPARTITIONNUM(COLUMN_NAME) = CURRENT DBPARTITIONNUM

Please let me know the reason and solution for this....

While creating the table is the table data partitioned? Then the distribution of data among database partitions is not as desired. Also, if the database is data partitioned then a better approach is to search in a particular data partition itself. Example: Suppose a table is data partitioned based on the LOAD DATE and it is say monthly partitioned. Then it is better to fetch the data from the particular month where it resides.

Did you try searching for DBPARTITIONNUM here? There are a handful of other discussions that mention it, something there might help.