Re: VARCHAR vs. TEXT - some performance numbers
Posted by:
Rob Blick
Date: July 31, 2006 09:48AM
Right on! That's it - the VARCHAR query pulls the results from the index, while the TEXT query has to grab the record. Like you suggested, if I index only on the first 100 characters in both tables, the difference disappears; both are slow, b/c the records have to be retrieved in both cases. Thanks so much for the insight!
Subject
Views
Written By
Posted
246326
July 31, 2006 06:57AM
66289
July 31, 2006 07:51AM
Re: VARCHAR vs. TEXT - some performance numbers
39143
July 31, 2006 09:48AM
29227
June 16, 2009 01:12PM
31805
June 16, 2009 10:17PM
29852
June 16, 2009 10:25PM
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.