i am using the hxtt drive to read records from CSV;i just need to use select operation;how can i write select operations which is not time consuming in case of large number of rows ;i also need a record count every time and i want all this within a single result set.
for example:i have written one query
select mainCSV.*,hdrCSV.*,( select count('*') from templet.txt) as recordcount
from templet mainCSV
right join header hdrCSV
how can i modify this query in order to improve its performance it takes 16 sec for total of 50,000 rows
select mainCSV.*,hdrCSV.*,(select top1 reccount('templet') from templet ) as recordcount
from templet mainCSV,header hdrCSV