Hi do i have to use index in my table where there is a column Num. Which must be unique, for each person. I my files i have search form to search by Num too.
Do i have to set Num column to UNIQUE? and create index for faster search?

__________________
Copyright by eRIC 2003 © !!!

UNIQUE is an index, so if the column data is unique to each row, then make it UNIQUE. Otherwise use EXPLAIN with your SELECT statement to see if the SQL is optimised to your table structure.

__________________
J de Silva
Learning Journal | GIDForums™ | GIDNetwork™ | GIDWebhosts™ | GIDSearch™

i'm using it right now.

__________________
Copyright by eRIC 2003 © !!!

eRIC,

Have you ever tried using EXPLAIN with your SELECT statements before? If you haven't, try inserting the word "EXPLAIN" to your SQL statement and see the results...

For example, if your SQL is something like this:

SELECT `name`, `number` FROM `client` WHERE `id`=256

try something like this instead:

EXPLAIN SELECT `name`, `number` FROM `client` WHERE `id`=256

Paste the results if you want me to 'explain' the report/result...

__________________
J de Silva
Learning Journal | GIDForums™ | GIDNetwork™ | GIDWebhosts™ | GIDSearch™

query: EXPLAIN SELECT `AdiTur` , `SicilNo` FROM `basa` WHERE `Id` =18

table | type |possible_keys |key| key_len|ref|rows|extra
--------------------------------------------------------
basa const PRIMARY PRIMARY 4 const 1


??????????

__________________
Copyright by eRIC 2003 © !!!