Question : Do varchar/text/longtext columns in MySQL occupy full length size in filesystem even for incomplete cells? Referring to this […]
Converting Varchar to Int error
Question : I came across an issue today, and while I was able to fix it, I am unsure what […]
Should I add an arbitrary length limit to VARCHAR columns?
Question : According to PostgreSQL’s docs, there’s no performance difference between VARCHAR, VARCHAR(n) and TEXT. Should I add an arbitrary […]
Changing all character varying to text across all tables and columns
Question : I’m trying to find a way to iterate over all of my tables and changing each charvar[n] to […]
CLOB vs Varchar2 performance in this case?
Question : From java application, I need to store the string which can be more than 4000 characters. I just […]
Should I created a different table to hold a big text / varchar field in MySQL 5.5.61 with Antelope file format?
Question : I read that newer version of MySQL save the big text fields apart from the rest of the […]
Composite index performance with varchar columns
Question : I have large fact tables with composite non-clustered indexes, something like this: NONCLSUTERED INDEX (OrderDate,OrderType,ClientKey,ItemKey,CustomerKey) The columns ending […]
What is the performance impact of using CHAR vs VARCHAR on a fixed-size field?
Question : I have an indexed column that stores an MD5 hash. Thus, the column will always store a 32-character […]
MySQL ‘copying to tmp table’ while enlarging VARCHAR
Question : One user called today because he has tried to enlarge a VARCHAR column (from 20 to 100) in […]
Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
Question : I am a newbie to MSSQL and am trying to convert an MSSQL table to Mapinfo Tab file […]