aspose file tools
The moose likes JDBC and Relational Databases 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 RabbitMQ in Depth this week in the Open Source forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 3740
    
  10

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.


[OCA 8 Book] [Blog]
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: 3740
    
  10

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