Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello,
I saw that the recommendation for adding indexes on a table is to add them on the Post-Write statement. However, for some reason when I put the statement for the creation of the index, it does nothing when I build the PosgreSQL dataset.
Is there anything I am doing wrong or some kind of button that I have to activate so the Post-write statement works?
I also checked the creation statement on a SQL code recipe and it works there.
Hi,
pre- and post-write statement on a SQL dataset are executed without needing to activate anything, unless you run a sql script recipe (not a sql query recipe), because these recipe assume total control on the SQL statements issued.
Can you attach screenshots of the Settings > Advanced tab of your dataset? And can you check pg_indexes to see if your index is indeed missing?