sql command 1

[atthevilla]

Crystal 10, Oracle 10.
I have a SQL Command that I want to use as a source for my Crystal report. It has only one field--ID. When used alone, it runs quickly. When I link other tables to it, it reads records only a few per minute. If I Show SQL Query, I notice that there are 2 separate statements. Is there any way to get this to run faster? Are SQL Commands not meant to link to other tables?

 

[Turkbear]

Hi,
A couple of questions:

What database and connectioin method?

Is the ID field linked to all the other tables or just to one and that one linked to another, etc.?

Is that field indexed in all tables?

When you access one of the linked tables withhout the SQL command, are the records read faster?






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[atthevilla]

I did say Oracle. It's an Oracle Server connection
The ID field is linked to just one table and that table linked to others. The ID field is indexed in all tables.
The records are read faster when I access the other linked tables without the SQL command.

 

[Turkbear]

Hi,
Sorry, I missed the Oracle 10 info.

Can you post the Sql that CR Created?

How is the report designed? Is the SQL command's ID used as a grouping field?





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

The issue is that the command is linking to the other tables locally, which is why you are seeing two separate statements and why the processing is so slow. It is much better to build all tables and corresponding links into the command so that the command is your sole datasource.

-LB