Tagged Questions

-1
votes
0answers
62 views

What is meant by Clustering index and Multilevel indices? [closed]

What is meant by Clustering Index and Multilevel Indices ? I could not find much when I googled it.
3
votes
1answer
287 views

Surrogate key / Primary key: Better to use an existing unique data field or create a key field?

I am not sure if this question has been asked or not. At least I couldn't find it. I am curious about a primary key in terms of efficiency with data searching and retrieval. This is a hypothetical ...
20
votes
4answers
2k views

What does “index” mean on RDBMSs? [closed]

I use indexes like most developpers do (mostly on... well ! index), but i'm sure there is a lot of subtle way to optimize a database using index. I'm not sure if it is specific to any implementation ...