Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

where is the index table gone

 
Samanthi perera
Ranch Hand
Posts: 510
  • 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
  • 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
  • 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: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • 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
  • 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: 4020
18
Eclipse IDE Flex Google Web Toolkit
  • 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