This week's book giveaway is in the Clojure forum.
We're giving away four copies of Clojure in Action and have Amit Rathore and Francis Avila on-line!
See this thread for details.
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

where is the index table gone

 
Samanthi perera
Ranch Hand
Posts: 510
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I heard that when we creating indexes it creating a new table.

Where did you hear this?
 
Samanthi perera
Ranch Hand
Posts: 510
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3899
16
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Samanthi perera
Ranch Hand
Posts: 510
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3899
16
Eclipse IDE Flex Google Web Toolkit
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
http://en.wikipedia.org/wiki/Index_%28database%29
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic