Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Indexes and big tables

Status
Not open for further replies.
zoomby

zoomby

Programmer
Aug 5, 2002
60
0
0
DE
hi

How are Indexes managed in MySql? I can create many indexes on the same columns but with different names (CREATE UNIQUE INDEX name...). But which index is then used? Is it possible to delete indexes?

bye
chris
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
111
EdLentz
EdLentz
penguinspeaks
  • Locked
  • Question
Stored Procedures and triggers
Replies
9
Views
120
penguinspeaks
penguinspeaks
BobThornton
  • Locked
  • Question
Drop/Truncate tables based on a stored procedures value 1
Replies
6
Views
151
BobThornton
BobThornton
fryertuk001
  • Locked
  • Question
New tables for each day, week, month
Replies
3
Views
82
spamjim
spamjim
Arthur Lewis
  • Locked
  • Question
How to effect a NOWAIT in the LOCK TABLES statement?
Replies
0
Views
46
Arthur Lewis
Arthur Lewis

Part and Inventory Search

Sponsor

Back
Top