Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Database doubt
air1ankit
asked
in
Databases
Oct 28, 2017
343
views
0
votes
0
votes
Why B or B+ tree is prefer for database indexing rather than AVL tree ????
databases
database-normalization
rdbms
air1ankit
asked
in
Databases
Oct 28, 2017
by
air1ankit
343
views
answer
comment
Follow
share this
share
1 comment
by
Tesla!
commented
Oct 29, 2017
reply
Follow
share this
for simple reason in AVL tree a node can have at most 2 child while B and B+ don't have any such restriction so if one node can more then 2 child then B and B+ will result in smaller tree than corresponding AVL tree
0
0
Please
log in
or
register
to add a comment.
Please
log in
or
register
to answer this question.
1
Answer
0
votes
0
votes
For searching perspective...its good.
Because it is multilevel indexing O(N2/M) which is less than O(NlogN)
Nau1994
answered
Oct 30, 2017
by
Nau1994
comment
Follow
share this
0 Comments
Please
log in
or
register
to add a comment.
← Previous
Next →
← Previous in category
Next in category →
Related questions
4
votes
4
votes
4
answers
1
Tuhin Dutta
asked
in
Databases
May 27, 2019
2,442
views
Doubt on database normalization for relation having all prime attributes
In a relation, if every attribute is prime but key may not be simple then the relation is in ______. A. 1NF B. 2NF C. 3NF D. BCNF
Tuhin Dutta
asked
in
Databases
May 27, 2019
by
Tuhin Dutta
2.4k
views
databases
database-normalization
rdbms
4
votes
4
votes
1
answer
2
air1ankit
asked
in
Databases
Oct 22, 2017
577
views
Doubt Database
What is difference between attributes set of cross product and attributes set of joine ???
air1ankit
asked
in
Databases
Oct 22, 2017
by
air1ankit
577
views
databases
database-normalization
rdbms
relational-algebra
1
vote
1
vote
1
answer
3
air1ankit
asked
in
Databases
Oct 19, 2017
301
views
Doubt database
What is basic difference between mandatory attributes and multivalued attributes???
air1ankit
asked
in
Databases
Oct 19, 2017
by
air1ankit
301
views
databases
database-normalization
rdbms
1
vote
1
vote
1
answer
4
Rahul Ranjan 1
asked
in
Databases
May 27, 2018
1,811
views
2NF Question.
Given a table $R(ABCDEF)$ $ABC -> D$ $ABD -> E$ $CD -> F$ $CDF -> B$ $BF -> D$ It's candidate keys are $ABC, ACD.$ So while checking for $2NF$, Can I say that $ABD -> E$ is not partially dependent because $ABD$ as a whole is not a part of candidate key even though $AB$ is a part of candidate key.
Rahul Ranjan 1
asked
in
Databases
May 27, 2018
by
Rahul Ranjan 1
1.8k
views
rdbms
databases
database-normalization
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...
Twitter
WhatsApp
Facebook
Reddit
LinkedIn
Email
Link Copied!
Copy