I am using Query Builder in Toad Data Point for fairly complex queries. I need to use a partition in my query so it runs faster. The only way I can do this is editing the query and manually adding the partition. Then every time I make a change in query builder, the manual change is removed and I have to add it again.
Is there a way in query builder to select a partition?
how can I make the manual edits permanent so query builder does not remove them when I make changes?