Performance Comparison Between String Indexes and Integer Indexes 
Author Message
 Performance Comparison Between String Indexes and Integer Indexes
Where can I find some information on the performance hit on extensively
using a 40-char string as primary keys (hence foreign keys as well) even if
a solution with an integer as primary keys exists?


Jim Min

Sun, 20 Jul 2003 01:13:43 GMT
 Performance Comparison Between String Indexes and Integer Indexes

Hi Jim,

There might not be any performance hit. It all depends on how and whether
the database compresses string keys and how the data are distributed.

I saw one product go from horrendous performance indexing strings to
phenomenal performance in just one product revision.

Your best bet is to simulate the situation on your database and actually
measure the times for retrieval and update.


Thu, 24 Jul 2003 12:09:52 GMT
 [ 2 post ] 

 Relevant Pages 

1. Performance of index on varchar2 vs integer

2. Index performance: integer vs. varchar

3. One-field INDEX performance VS multiple fields index

4. INDEX( index, index, ... )

5. sp_cursorfetch much slower on varchar index than integer?

6. Help: index search with integer key fields

7. Indexes w/8i Integer or bitmap char etc.?

8. Temporary Index for integer expression

9. Indexes and Timestamp Comparisons

10. Indexes and Timestamp Comparisons

11. How to split string into integer and string

12. Unicode strings cause index scans on SQL 2k?

Powered by phpBB® Forum Software