Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Change or Prioritise Table Index Post Reply Post New Topic
Author Message
nix1016
Groupie
Groupie


Joined: 07 Jun 2010
Online Status: Offline
Posts: 40
Quote nix1016 Replybullet Topic: Change or Prioritise Table Index
    Posted: 26 Jun 2011 at 10:57pm
I have a report that only uses one table. By default our database index for this table uses dates as its main index and I assume Crystal Reports duplicates this, however, it makes the report extremely slow to the point of freezing/not working. If I take away the date filters from the SQL query then the report gets produced much faster.
 
Is there anyway that I can continue to use the date range in its sql query but prioritse another index field over this in crystal? I have tried re-arranging the sql query to put the date range at the very end but it doesn't make any difference. Also, I tried adding grouping/sorting of other index fields above the date field but also to no-avail.
 
Anyone know anything else I can try? Thanks in Advance!


Edited by nix1016 - 26 Jun 2011 at 10:57pm
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 06 Jul 2011 at 6:53am
you need to index on the server.
you have the sp parameterized?
sharona
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.