Category Archives: Database
Derby database notes
I’ve set the %DERBY_HOME% environment variable so can start the Derby ij tool using: java -jar %DERBY_HOME%\lib\derbyrun.jar ij and also see the system info (e.g. java version etc) using java -jar %DERBY_HOME%\lib\derbyrun.jar sysinfo. The ij tool needs to be started … Continue reading
SQL Server indexing word breaker
I’ve been looking at the way indexing is done on the Knowledge Network. This post and also this one explain why you cannot use different word breakers for different columns in the same table. In short, all columns must use … Continue reading
