We are facing performance issues while deploying VDB for Netezza database version 18.104.22.168 . We figured out that it because of metadata fetch. There are about 1000 tables in schema and for each table it is fetching PK, FK and indexes. Each single query is taking about 500 to 1200 ms and overall more than 30 minutes to deploy VDB and same for subsequent refresh.
Are there any suggestions to tune initial metadata fetch or refresh?
Also we know that we don’t use PK, FK and indexes in our database, is it possible to configure VDB not to fetch these, which should save bulk of the time?
I am using teiid 9.1.3 admin api to create VDB dynamically and WildFly 10.0.0
You can use the importer related properties  for controlling what is imported (tables, keys, etc.). To really limit the metadata imported, I would suggest to filter on which tables are needed.