'Optimize "select * from table" query with 200millionen entries - DB2 database
I have simple select * from table query but the data has ~200 million of dataentries. How can I optimize the query and still take the whole data from the table? The database is db2.
Solution 1:[1]
Enable parallelism by setting the current degree = any. This will utilize multiple processors to satisfy the query faster. If you have any where clause search conditions, indexing may help.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Patrick Bossman |