This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes where is the index table gone Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "where is the index table gone" Watch "where is the index table gone" New topic
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: 3700
    
    5

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: 3700
    
    5

http://en.wikipedia.org/wiki/Index_%28database%29
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: where is the index table gone
 
Similar Threads
Gradebook
hashing problem
How Creating an Index on Table helps Database engine to do fast Search
incrementing numbers in database when a new object is added
assigning a value the same as an index