Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Under what conditions should indexes be used in DBMS?
Home
DBMS
Under what conditions should indexes be used in DBMS?
0
votes
asked
Apr 2, 2020
in
DBMS
by
rajeshsharma
Under what conditions should indexes be used in DBMS?
#dbms-indexes
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Apr 2, 2020
by
amita rallin
Indexes can be created to enforce uniqueness, to facilitate sorting, and to enable fast
retrieval by column values. A good candidate for an index is a column that is
frequently used with equal conditions in WHERE clauses.
https://madanswer.com/selenium
Your comment on this answer:
Email me at this address if a comment is added after mine:
Email me if a comment is added after mine
Privacy: Your email address will only be used for sending these notifications.
Related questions
0
votes
Q: Describe the four types of indexes in DBMS?
asked
Apr 2, 2020
in
DBMS
by
rajeshsharma
#dbms-index-types
0
votes
Q: Which of the following method is used, on a conditional frequency distribution, in order to display frequency of few samples derived under few conditions?
asked
Oct 22, 2020
in
NLP using Python
by
rahuljain1
#nlp-view
0
votes
Q: What is Enterprise Resource Planning (ERP), and what kind of a database is used in an ERP application in DBMS?
asked
Mar 31, 2020
in
DBMS
by
amita rallin
#dbms-enterprise-resource-planning
#erp
#erp-applications
0
votes
Q: What is deadlock in DBMS? How can it be avoided in DBMS? How can it be resolved once it occurs in DBMS?
asked
Apr 2, 2020
in
DBMS
by
rajeshsharma
#dbms-deadlock
0
votes
Q: A string has a mass of 100gm & is under a tension of 10N. What should be its length if the speed of transverse waves is to be 10m/s on the string.
asked
Oct 7, 2021
in
Class-XI-PHYSICS
by
Sandeepthukran
cbse
0
votes
Q: Which of the following should be covered under the security policy?
asked
Aug 17, 2021
in
Security Assessment
by
Robindeniel
security-policy
0
votes
Q: In which of the following conditions can the Bernoulli equation not be used?
asked
Oct 3, 2021
in
Class-XI-PHYSICS
by
Sandeepthukran
cbse
0
votes
Q: A table has two indexes defined. Which one will be used by the SEARCH?
asked
Dec 10, 2023
in
Cobol
by
sharadyadav1986
searchindex
0
votes
Q: dbms viva questions
asked
Aug 27, 2022
in
DBMS
by
Robin
dbms
questions
answers
viva
0
votes
Q: What is DBMS?
asked
Dec 13, 2020
in
DBMS
by
SakshiSharma
#what-is-dbms
#dbms
...