How to Force “postgresql” to use Unique Index When Together Non-Unique Index
I have a select query that uses two indexes (one of a unique index, one of a non-unique index).
They always use first index of the where clause. How can I force that query to use a unique index whether any sequential? My query create by ORM, I can't adjust sequential.
postgresql
edited Nov 13 '18 at 10:21
Universal Link
13012
asked Nov 13 '18 at 9:52
s97712s97712
256
add a comment |
I have a select query that uses two indexes (one of a unique index, one of a non-unique index).
They always use first index of the where clause. How can I force that query to use a unique index whether any sequential? My query create by ORM, I can't adjust sequential.
postgresql
edited Nov 13 '18 at 10:21
Universal Link
13012
asked Nov 13 '18 at 9:52
s97712s97712
256
add a comment |
I have a select query that uses two indexes (one of a unique index, one of a non-unique index).
They always use first index of the where clause. How can I force that query to use a unique index whether any sequential? My query create by ORM, I can't adjust sequential.
postgresql
edited Nov 13 '18 at 10:21
Universal Link
13012
asked Nov 13 '18 at 9:52
s97712s97712
256
I have a select query that uses two indexes (one of a unique index, one of a non-unique index).
They always use first index of the where clause. How can I force that query to use a unique index whether any sequential? My query create by ORM, I can't adjust sequential.
postgresql
postgresql
edited Nov 13 '18 at 10:21
Universal Link
13012
asked Nov 13 '18 at 9:52
s97712s97712
256
edited Nov 13 '18 at 10:21
Universal Link
13012
asked Nov 13 '18 at 9:52
s97712s97712
256
edited Nov 13 '18 at 10:21
Universal Link
13012
edited Nov 13 '18 at 10:21
Universal Link
13012
edited Nov 13 '18 at 10:21
Universal Link
13012
13012
asked Nov 13 '18 at 9:52
s97712s97712
256
asked Nov 13 '18 at 9:52
s97712s97712
256
asked Nov 13 '18 at 9:52
s97712s97712
256
256
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You create a partial index from which you exclude the rows that do not satisfy the index unique values.
https://www.postgresql.org/docs/8.0/indexes-partial.html
answered Nov 13 '18 at 10:20
VictorqeduVictorqedu
1277
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53278225%2fhow-to-force-postgresql-to-use-unique-index-when-together-non-unique-index%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You create a partial index from which you exclude the rows that do not satisfy the index unique values.
https://www.postgresql.org/docs/8.0/indexes-partial.html
answered Nov 13 '18 at 10:20
VictorqeduVictorqedu
1277
add a comment |
You create a partial index from which you exclude the rows that do not satisfy the index unique values.
https://www.postgresql.org/docs/8.0/indexes-partial.html
answered Nov 13 '18 at 10:20
VictorqeduVictorqedu
1277
add a comment |
You create a partial index from which you exclude the rows that do not satisfy the index unique values.
https://www.postgresql.org/docs/8.0/indexes-partial.html
answered Nov 13 '18 at 10:20
VictorqeduVictorqedu
1277
You create a partial index from which you exclude the rows that do not satisfy the index unique values.
https://www.postgresql.org/docs/8.0/indexes-partial.html
answered Nov 13 '18 at 10:20
VictorqeduVictorqedu
1277
answered Nov 13 '18 at 10:20
VictorqeduVictorqedu
1277
answered Nov 13 '18 at 10:20
VictorqeduVictorqedu
1277
answered Nov 13 '18 at 10:20
VictorqeduVictorqedu
1277
1277
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53278225%2fhow-to-force-postgresql-to-use-unique-index-when-together-non-unique-index%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
