Skip to Content
0
Former Member
Jan 11, 2012 at 03:55 PM

Database Command Crystal Implementation Question

26 Views

Hi,

I have a report that is using a database command as its data source. The command queries a huge table. Since the report was last saved in CMC, a new index has been created over the table that should substantially reduce the number of records read for the command (more of the WHERE clause fields are in the index), but that index is not being used.

I was wondering if Crystal uses database Packages (or some other technique) to "compile" the access plan for the Command once, then use that compiled code for subsequent runs.

Can anyone tell me if this is the case? If it is, I'm thinking that changing the command (add a space character somewhere) and re-saving the report will cause it to use the new index, as the access plan will be re-evaluated.

Thanks for the help,

Carl

P.S., In case it's inportant, the database is on an IBM AS/400 (iSeries) box...