I have a query...
In our production system there are some load tables which gets populated on daily bases with thousands of rows. these tables doesn't have indexes defined on them. Because cost of creating indexes can be more than reading the tables. These tables are read only once.
Can we improve the performance of these tables while reading?
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
If the tables are to be read only once sequentially and they are merely replicas of existing sequential files, why take the time to load the data into database tables and then read it again only once (sequentially)?
Seems like it would be much less overhead to simply read the data in the qsam file(s).