Can I add an index on a view in mariaDBHow does database indexing work?How can I prevent SQL injection in PHP?Add a column with a default value to an existing table in SQL ServerSQL update from one Table to another based on a ID matchFULLTEXT indexes in MariaDB 10How to save views in MariaDB/MySQL?MariaDB / InnoDB: index corruption - why?MariaDB slow left join using modified indexmariadb not using the correct index with subquerymariadb non selective index on foreign keys
Is this n-speak?
These were just lying around
How to remove ambiguity: "... lives in the city of H, the capital of the province of NS, WHERE the unemployment rate is ..."?
Why are Gatwick's runways too close together?
Email address etiquette - Which address should I use to contact professors?
What is a good class if we remove subclasses?
Super Duper Vdd stiffening required on 555 timer, what is the best way?
What is the status of the F-1B engine development?
When does Tiana, Ship's Caretaker check card type?
80's/90's superhero cartoon with a man on fire and a man who made ice runways like Frozone
What ability do tools use?
Why did I get only 5 points even though I won?
Basic properties of expectation in non-separable Banach spaces
Lengthened voiced stops and the airstream through the nose
Breadcrumb history decision
On math looking obvious in retrospect
What is this "Table of astronomy" about?
How to create events observer that only call when REST api dispatch events?
What does the phrase "pull off sick wheelies and flips" mean here?
Boss wants me to ignore a software license
Normalization constant of a planar wave
Markov-chain sentence generator in Python
Bitcoin successfully deducted on sender wallet but did not reach receiver wallet
How to take the beginning and end parts of a list with simpler syntax?
Can I add an index on a view in mariaDB
How does database indexing work?How can I prevent SQL injection in PHP?Add a column with a default value to an existing table in SQL ServerSQL update from one Table to another based on a ID matchFULLTEXT indexes in MariaDB 10How to save views in MariaDB/MySQL?MariaDB / InnoDB: index corruption - why?MariaDB slow left join using modified indexmariadb not using the correct index with subquerymariadb non selective index on foreign keys
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I need to create an index on a view in mariaDB. Is this possible?
Note that, I can't create an index on tables since admininstrator permissions are not given to access tables.
sql mariadb
asked Mar 27 at 8:45
KancTercKancTerc
236 bronze badges
add a comment |
I need to create an index on a view in mariaDB. Is this possible?
Note that, I can't create an index on tables since admininstrator permissions are not given to access tables.
sql mariadb
asked Mar 27 at 8:45
KancTercKancTerc
236 bronze badges
Create the index on the base table instead.
– jarlh
Mar 27 at 8:49
Well the problem is i have no access to the table. No permission to view the tables. I was given only a few particular views, which contain lots of data
– KancTerc
Mar 27 at 8:52
add a comment |
I need to create an index on a view in mariaDB. Is this possible?
Note that, I can't create an index on tables since admininstrator permissions are not given to access tables.
sql mariadb
asked Mar 27 at 8:45
KancTercKancTerc
236 bronze badges
I need to create an index on a view in mariaDB. Is this possible?
Note that, I can't create an index on tables since admininstrator permissions are not given to access tables.
sql mariadb
sql mariadb
asked Mar 27 at 8:45
KancTercKancTerc
236 bronze badges
asked Mar 27 at 8:45
KancTercKancTerc
236 bronze badges
edited Mar 27 at 8:53
KancTerc
asked Mar 27 at 8:45
KancTercKancTerc
236 bronze badges
asked Mar 27 at 8:45
KancTercKancTerc
236 bronze badges
asked Mar 27 at 8:45
KancTercKancTerc
236 bronze badges
236 bronze badges
Create the index on the base table instead.
– jarlh
Mar 27 at 8:49
Well the problem is i have no access to the table. No permission to view the tables. I was given only a few particular views, which contain lots of data
– KancTerc
Mar 27 at 8:52
add a comment |
Create the index on the base table instead.
– jarlh
Mar 27 at 8:49
Well the problem is i have no access to the table. No permission to view the tables. I was given only a few particular views, which contain lots of data
– KancTerc
Mar 27 at 8:52
Create the index on the base table instead.
– jarlh
Mar 27 at 8:49
Create the index on the base table instead.
– jarlh
Mar 27 at 8:49
Well the problem is i have no access to the table. No permission to view the tables. I was given only a few particular views, which contain lots of data
– KancTerc
Mar 27 at 8:52
Well the problem is i have no access to the table. No permission to view the tables. I was given only a few particular views, which contain lots of data
– KancTerc
Mar 27 at 8:52
add a comment |
1 Answer
1
active
oldest
votes
No, you cannot create indexes on a View in MariaDB.
Indeed, Views are not real relations, but simply aliases on relations (tables).
You could have created indexes on a Materialized View but MariaDB does not implement (in a native way) Materialized Views as of today.
answered Mar 27 at 9:26
Nicolas PayartNicolas Payart
74412 silver badges23 bronze badges
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%2f55372988%2fcan-i-add-an-index-on-a-view-in-mariadb%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
No, you cannot create indexes on a View in MariaDB.
Indeed, Views are not real relations, but simply aliases on relations (tables).
You could have created indexes on a Materialized View but MariaDB does not implement (in a native way) Materialized Views as of today.
answered Mar 27 at 9:26
Nicolas PayartNicolas Payart
74412 silver badges23 bronze badges
add a comment |
No, you cannot create indexes on a View in MariaDB.
Indeed, Views are not real relations, but simply aliases on relations (tables).
You could have created indexes on a Materialized View but MariaDB does not implement (in a native way) Materialized Views as of today.
answered Mar 27 at 9:26
Nicolas PayartNicolas Payart
74412 silver badges23 bronze badges
add a comment |
No, you cannot create indexes on a View in MariaDB.
Indeed, Views are not real relations, but simply aliases on relations (tables).
You could have created indexes on a Materialized View but MariaDB does not implement (in a native way) Materialized Views as of today.
answered Mar 27 at 9:26
Nicolas PayartNicolas Payart
74412 silver badges23 bronze badges
No, you cannot create indexes on a View in MariaDB.
Indeed, Views are not real relations, but simply aliases on relations (tables).
You could have created indexes on a Materialized View but MariaDB does not implement (in a native way) Materialized Views as of today.
answered Mar 27 at 9:26
Nicolas PayartNicolas Payart
74412 silver badges23 bronze badges
answered Mar 27 at 9:26
Nicolas PayartNicolas Payart
74412 silver badges23 bronze badges
answered Mar 27 at 9:26
Nicolas PayartNicolas Payart
74412 silver badges23 bronze badges
answered Mar 27 at 9:26
Nicolas PayartNicolas Payart
74412 silver badges23 bronze badges
74412 silver badges23 bronze badges
add a comment |
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
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%2f55372988%2fcan-i-add-an-index-on-a-view-in-mariadb%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
Create the index on the base table instead.
– jarlh
Mar 27 at 8:49
Well the problem is i have no access to the table. No permission to view the tables. I was given only a few particular views, which contain lots of data
– KancTerc
Mar 27 at 8:52