Hints in Query Builder

Toad Data Point
1

Hi,

Been using Data Point for a while now and have a question:

Is there a way to add Hints in the Query Builder?

My work around is to use Query Builder to generate SQL, then I cut and paste in a new Editor window and add my Hints there. Inefficient as all getout, but I haven’t been able to find anywhere I can put in Hints in the Query Builder.

2

Unfortunately Query Builder does not support hints.

I created enhancement task QAT-3643 to track your request.

Regards

Aleksey

3

Really? Seems like it would be such a simple thing. Almost like adding a comment. Anyways, thanks Aleksey, it was driving me nuts thinking I was something that I thought was basic.

4

You are right it looks simple but hints are platform specific and supporting them is more than just adding and keeping comment. For example in SQL Server and MySQL hints are extensions to the SQL standard.

So supporting hints will take some time but hopefully we will implement it.

Regards

Aleksey

5

Has there been any progress to being able to add query hints in the query builder interface?

Switching to the Query tab to manually insert this works but seems pretty inefficient.

regards

Trevor

6

We are almost complete on features for TDP 4.3. We have been focusing on a rewrite of the pivot grid and the hints didn’t get into this release. I will escalate it for the next release. Sorry[:$]