wood burning stoves 2.0*
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 OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP 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
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3712
    
    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
author
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3712
    
    5

http://en.wikipedia.org/wiki/Index_%28database%29
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: where is the index table gone