DISQUS

Hello! 20bits is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

20bits.com Jump to website »

Subscribe
- New Comments
Community
Top Commenters
- Jesse Farmer
  65 comments · 7 points
- Ratnam Raj
  5 comments · 1 points
- utsuprainfra
  3 comments · 1 points
- PDFoxy
  3 comments · 2 points
- adamheroku
  2 comments · 3 points
Popular Threads
Recent Comments
- The people go outside?
  17 hours ago by wholesale korean clothing
  
  in The State of the Facebook Platform
- to bold write just *text* wullah
  23 hours ago by j03l5k1
  
  in Easter Eggs in Facebook Chat | 20bits
- forgot (^^^) the shark
  1 day ago by yo!
  
  in Easter Eggs in Facebook Chat | 20bits
- Hi Jesse, I just came across your site while I was searching for more details on the influence function. You have mentioned that "calculating the influence function exactly is NP-hard" -...
  1 day ago by Nishant
  
  in Social Network Notification Strategies
- The Erlang documentation covers its approach to in-place code upgrades here: http://erlang.org/doc/design_principles/part_frame.html . In particular, see the sections "Releases" and...
  1 day ago by Dave
  
  in Erlang: A Generalized TCP Server | 20bits

20bits

Jump to original thread »

Author

Interview Questions: Database Indexes | 20bits

Started by Jesse Farmer · 7 months ago

No excerpt available. Jump to website »

12 comments

Arun C
11 months ago

Great answers. Very helpful!

reply

getachew
10 months ago

it is very good for giving insight about indexes but i wish if you extend the definition thank u

reply

Eugene
8 months ago

Thank you for the definition, and explanation. I liked the explanation about the b-tree, an example with the right branch is very helpful. Now i know indexes : ))). Thanks.

reply

Nguyen Pham
8 months ago

Great entry. Thank you!

reply

Nataraj M Basappa
8 months ago

Best explanation, very helpful thank

reply

Eli
7 months ago

I really liked this entry, thanks for posting it.
How does a DB system decide when create a certain index ? Does it happen the first time some search is executed ?

reply

Catrope
6 months ago

The DBMS doesn't decide that, the user does when creating the table (or later).

reply

mosaad shouman
6 months ago

thanks

reply

boss
3 months ago

loved it

reply

Duc Anh
2 months ago

Thanks so much

reply

ahmed
2 weeks ago

thanks what about dense and nondense index

reply

buy_search_engine
1 week ago

Yes, the indexing make the alteration is too costly, sometimes i would prefer add a new rows first and deleted the old one, it makes the altering quicker.

reply

Add New Comment

Returning? Login