MySQL Forums
Forum List  »  Performance

Column Type and Performance
Posted by: Craig Matthews
Date: March 30, 2005 02:00AM

Hi,

How does column type affect performance of SELECTs and INSERTs?

1. If an indexed column is CHAR(1) or tinyint? Is one faster than the other?

2. If an indexed column is mediumint versus varchar(20)?

I would imagine that indexing shouldnt make that much of a difference based on column type?

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Column Type and Performance
2510
March 30, 2005 02:00AM
1746
March 30, 2005 07:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.