Print Page | Close Window

index is blue color marker for primary key

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19709
Printed Date: 06 May 2024 at 1:33am


Topic: index is blue color marker for primary key
Posted By: bkel
Subject: index is blue color marker for primary key
Date Posted: 25 Jun 2013 at 12:35pm
I am trying to understand the Links Tab in the database expert- where it shows the Index colors. I have read that mostly primary keys are Red - the 1st indexed. ALLL of my tables from Access Primary Keys - are showing ANY color Other than RED. but Red is assigned to NON primary keys. Please explain???? - what does multi colored ones mean???

thanks,
bkel


Replies:
Posted By: lockwelle
Date Posted: 26 Jun 2013 at 4:36am
in all honesty, I've never worried about the colored flags. As long as you are joining on a indexed field, the join will be faster.

You don't need to join on an indexed field.

Well that's my two cents

Posted By: praveeng
Date Posted: 26 Jun 2013 at 7:18am
Hi Kelly,
 
Adding to above suggestion,
 
Linking to a field in a table that has an index will speed the retrieval of data from the database, so if an indexed field is available, try to use it. An index is created by a database designer or database administrator and can involve a single field or a group of fields.  Index arrows are pentagons that are color-coded; the color tells you whether it was the first index created, second index created, etc., It is important to note that indexes are created at the database level and not in Crystal Reports. Crystal can use only existing indexes.

When linking database tables together, you may link on any field you choose ”there is not a requirement to link to or from an indexed field. For performance reasons, however, you may still want to try to link to indexed fields anyway. You may see improved record retrieval speeds.

--Praveen G



-------------
Praveen Guntuka,
praveen_guntuka@yahoo.com

Posted By: bkel
Date Posted: 26 Jun 2013 at 12:33pm
I understand all of that - however - I do not understand WhY my primary key from Access(the database) is NOT showing up as RED - IT IS THE PRIMARY index????
thanks,
bkel

Posted By: lockwelle
Date Posted: 27 Jun 2013 at 4:38am
perhaps it was not the first index created on the table?

After all the legend does not say Primary Index, just first, second, etc.


Print Page | Close Window