How the Field Programmable Gate Array improves the performance of the sql queries in netezza database?
FPGA is located on each SPU. Netezza can do hardware upgrade through software by using FPGA.
When reading data from the disk, FPGA helps in filtering unnecessary data before getting loaded into memory on each SPU.
This way FPGA avoids presenting excessive amount of data to the SPU memory.