Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add @DisableSelfJoin and @EnableSelfJoin #61

Open
jeanbisutti opened this issue Apr 5, 2020 · 0 comments
Open

Add @DisableSelfJoin and @EnableSelfJoin #61

jeanbisutti opened this issue Apr 5, 2020 · 0 comments
Labels
✨ feature New feature or request sql SQL annotations

Comments

@jeanbisutti
Copy link
Collaborator

jeanbisutti commented Apr 5, 2020

Description

In many cases, SQL self-joins don't seem to be the best option for performance: Markus Winand 1, Markus Winand 2.

The use of a window function or a pivot may be a better alternative. With window function we have also to pay attention to excessive sorts.

A test with @DisableSelfJoin will fail if at least one SQL self-join is detected. The user may attribute a global scope to this annotation. In some specific cases, @DisableSelfJoin can be disabled at method level with @EnableSelfJoin.

@jeanbisutti jeanbisutti added ✨ feature New feature or request sql SQL annotations labels Apr 5, 2020
Repository owner deleted a comment from FTarfasse Jul 31, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
✨ feature New feature or request sql SQL annotations
Projects
None yet
Development

No branches or pull requests

1 participant