self doubt

0 votes

26 views

For range queries every B+ tree index requires less I/O than a full table scan.

can anyone explain?

databases
b-tree
trees

asked Jan 2 in Databases by newdreamz a1-z0 Active (1.5k points) | 26 views

You do not have permission to perform this operation

Please log in or register to answer this question.

0 Answers

← Prev. Qn. in Sub. Next Qn. in Sub. →

← Prev. Next →

Related questions

0 votes

1 answer

Doubt regarding deletion from a B-tree
After deleting an element from a B-tree,I could rearrange the tree in several ways,that would still complies to the rules of B-trees.But,we are supposed to follow a certain set of rules for rearranging the tree after deleting an element. Why is that ?

asked Mar 1, 2018 in Algorithms by Mathews George (7 points) | 121 views

b-tree
data-structure
trees

+1 vote

1 answer

B+ tree
$\text{Insertion Sequence}$ : $8,5,1,7,3,12,9,6$ Can someone plz show the Sequence of insertion in B+ tree step by step Thanks

asked Dec 7, 2017 in Databases by Pawan Kumar 2 Active (4.2k points) | 147 views

b-tree
trees
bplustrees

+1 vote

2 answers

B+ Tree Self Doubt
what is the minimum and maximum number of keys for non-leaf nodes and leaf nodes for B+ Tree of order p?

asked Nov 23, 2018 in Databases by aditi19 Active (3.9k points) | 158 views

b-tree
databases
indexing
multilevel

0 votes

2 answers

Self doubt
Consider a B+ tree in which the maximum number of keys in a Internal node is 5 and maximum number of keys in a leaf node is 4. What is the minimum number of keys in any non-root node?

asked Oct 30, 2018 in Databases by jatin khachane 1 Loyal (6.8k points) | 53 views

databases
b-tree

+1 vote

1 answer

Self doubt B tree B+tree
To insert key into level L B/B+ tree maximum new nodes require to create?? And how?

asked Jan 6, 2018 in Databases by Anshul Shankar Active (1k points) | 94 views

databases
b-tree
binary-search-tree

0 votes

1 answer

B+ tree doubt
Consider a B+ -tree in which the maximum no. of keys in a root is 11. What will be minimum no. of keys in a non-root node? What will be the same in a B-Tree Please also refer the source from where clear-cut formulae are given

asked Dec 15, 2018 in Databases by Subham Nagar Active (1k points) | 78 views

b-tree
databases

0 votes

2 answers

doubt
Why B-tree & B+ tree is used in database indexing instead of other tree like BST, Binary tree etc??

asked Dec 8, 2018 in Databases by MRINMOY_HALDER Active (1.7k points) | 38 views

databases
b-tree

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 Blog Comments

Nah I just meant, maybe consignment no. was...
Only when they update it'll come -- what can I do...

You do not have permission to perform this operation

Please log in or register to answer this question.

0 Answers

Related questions

Recent Posts

Recent Blog Comments