[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: SQL performance question



On Mon, Nov 20, 2006 at 01:13:55PM +0100, Dirk wrote:
> Which one is faster? Indices of varchar(8) or int(11)?
> 
> Or is there no difference at all?
> 

It probably depends on:
 * your particular DBMS
 * your access pattern (few reads/many writes or many reads/few writes)
 * the size of your tables
 * many other things

Regards,

-Roberto

-- 
Roberto C. Sanchez
http://people.connexer.com/~roberto
http://www.connexer.com

Attachment: signature.asc
Description: Digital signature


Reply to: