Solved

Cardinality;PRIMARY Index;Indexes

Posted on 2006-07-19
3
891 Views
Last Modified: 2008-02-26
Can someone please explain what these terms mean/do?

Cardinality;PRIMARY Index;Indexes

I've seen them in phpmyadmin and are wondering what they are used for.
0
Comment
Question by:mnb93
  • 2
3 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
Cardinality:
  means how many different values you have for 1 column. for a primary key or unique constraints , it must be 1
 

primary key:
  is a constraint enforcing you have each value only once in the table. trying to update or insert duplicate values will be rejected

indexes:
  like in books, a index is to find information quicker.
0
 
LVL 5

Author Comment

by:mnb93
Comment Utility
if I set something to an index that does what? (one hand typing atm ,soory.)
0
 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
an index is a additional structure besides the table, kept up-to-date automatically, that helps WHERE clause to be fast.

like Persons table : PersonID, PersonName

if you don't put a index on PersonID, getting a single row can take more and more time, the larger the table.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now