db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Calum Miller <ca...@idmltd.biz>
Subject Query Performance and SYSCS_UTIL.SYSCS_IMPORT_TABLE
Date Thu, 01 Dec 2005 11:36:11 GMT
Hi,

We are using SYSCS_UTIL.SYSCS_IMPORT_TABLE to bulk import data into an 
empty table from a CSV file. Currently, the CSV data is not ordered by 
primary key. If we ordered this CSV file by primary key before importing 
does this A) improve the load time or/and B) improve the query performance?

Thanks in advance

Calum Miller
http://www.informed-decision-making.com


Mime
View raw message