All Questions

Tagged with
Filter by
Sorted by
Tagged with
-1
votes
0answers
13 views

Does refreshing indexes on a table, helps to improve inserts? [closed]

I've being doing some research about this, and I do understand why indexing might slow you down on insert, after reading Insert - Use the index Luke!. But I was under the impression that refreshing ...
5
votes
1answer
1k views

What would be the maximum number of records that can be indexed with a three levels B-tree ? B+ tree?

I am learning dynamic tree-structure organizations and how to design databases. Consider a DBMS with the following characteristics : file pages with size 2048 bytes pointers of 12 bytes page header ...
4
votes
1answer
243 views

B Tree and B+Tree differences

I'm studying B+ Tree and B Tree and I would like to understand two things about it, if someone can clarify it to me I would appreciate: Why can I store more search keys on an B+ Tree Index? My guess ...