On Mon, Nov 20, 2006 at 02:39:47PM +0000, Dave Ewart wrote: > On Monday, 20.11.2006 at 09:05 -0500, Roberto C. Sanchez wrote: > > > 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 > > Will also depend on whether you are select-ing/indexing on *equality* or > on partial matches (i.e. substrings for varchar, or > greater-than/less-than for integers). > I missed that one. > I'm curious as to why you've asked such an abstract question, Roberto: > do you have a database application in mind whether you are able to use > either strings or integers for a particular storage type? > It's not my app. It's Dirk's. Look at the attribution :-) Regards, -Roberto -- Roberto C. Sanchez http://people.connexer.com/~roberto http://www.connexer.com
Attachment:
signature.asc
Description: Digital signature