Hi guys
I have a large database (actually a bunch of large databases) that a
running as the backends of radius servers running voip accounting.
The databases are getting quite large now and some queries are taking >
5min to return. Now I read somewhere that indexing varchar fields is not
particularly worth it especially if you are only doing queries
occasionally. I am doing 200-500 inserts per min but only a query run on
this particular field when I want to compare my flat file logs against
whats in the DB to see if they match for billing purposes.
Can someone inform me as to whether an index on the following field:
h323ConfID varchar(64) DEFAULT '' NOT NULL
Which contains data resembling the following:
41A4DCE3 8CF2D611 85170004 75AE73D4
which is most likely unique, but not guaranteed so, is going to be worth
it?
--
Peter Nixon
http://www.peternixon.net/
PGP Key: http://www.peternixon.net/public.asc