| Author |
where is the index table gone
|
Samanthi perera
Ranch Hand
Joined: Jan 08, 2010
Posts: 510
|
|
I have created a table called Student and added recorded to them.
Then i created index for student table.
i use this
I am using MySql ,I can't fine any new table still.
I heard that when we creating indexes it creating a new table.
|
 |
Paul Sturrock
Bartender
Joined: Apr 14, 2004
Posts: 10336
|
|
I heard that when we creating indexes it creating a new table.
Where did you hear this?
|
JavaRanch FAQ HowToAskQuestionsOnJavaRanch
|
 |
Samanthi perera
Ranch Hand
Joined: Jan 08, 2010
Posts: 510
|
|
|
I went to an interview,They said when we making indexes it creating a hash value for colum and it creates a new table and save it in that table.
|
 |
Scott Selikoff
Saloon Keeper
Joined: Oct 23, 2005
Posts: 3652
|
|
|
I'd read a primer on database indexes (ask Google). Some systems offer meta-data tables that contain information about the indexes, but aren't actually the index. For example, in some software creating an index would add a line to a table to show the existence of the index. But this is purely representational.
|
My Blog: Down Home Country Coding with Scott Selikoff
|
 |
Samanthi perera
Ranch Hand
Joined: Jan 08, 2010
Posts: 510
|
|
anyway can anyone give me good tutorials for databse indexing ,I search google still not found good one.
I am using MySql Server.
|
 |
Scott Selikoff
Saloon Keeper
Joined: Oct 23, 2005
Posts: 3652
|
|
|
http://en.wikipedia.org/wiki/Index_%28database%29
|
 |
 |
|
|
subject: where is the index table gone
|
|
|