Is there any advantage to defining relationships for tables and queries

In general will I see any query performance gains?

More of a DB2 guy myself.

Regards

Phil

Nov 13 '05 #1

1719

For JET dbs, the Relationships window sets up the Foreign Key
relationships between tables.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

runners4bush wrote:

In general will I see any query performance gains?

More of a DB2 guy myself.

Nov 13 '05 #2

David Schofield

On 16 Sep 2004 08:31:00 -0700, ru**************@gmail.com
(runners4bush) wrote:

In general will I see any query performance gains?
More of a DB2 guy myself.
Regards
Phil

Hi Phil
Relationships as such are for data integrity and consistency (good
things to have!), adding them CAN make performance slower, eg when new
records are added or deleted. . They are not necessary in read-only
databases.

HOWEVER

After design, performance depends mainly on having the right indexes.
Access routinely creates indexes based on the relationships you
define, so if you skip the relationships you will need to check that
you have set up indexes yourself where appropriate, eg on commonly
joined fields

On balance I suggest you set up all applicable relationships.

David
David

Nov 13 '05 #3

by: cvchen | last post by:

Hello, I'm implementing a data dictionary (catalogging system) that can be searched in several ways. I finished the first version without using any databases, I just had pickled dictionaries to...

Python

Table relationships lost when ran splitting wizard. WHY?

by: Ed | last post by:

I am running Access 2002 and just ran the built in Access wizard for splitting a database into a back end (with tables) and front end (with queries, forms, modules, etc.). After running the...

Microsoft Access / VBA

Phantom Relationships

by: Max | last post by:

Hi. I really hope someone can help me. Going slowly insane with this problem. I have a two Access 2000 databases. One is the backend containing tables and some admin queries. The other is the...

Microsoft Access / VBA

A2K - how to copy a database structure with relationships?

by: Deano | last post by:

I'm experiencing bloat problems when I restore my backup files. Users can take a look at the reports of any previous backup without having to ensure they have a backup of their current data - this...

Microsoft Access / VBA

Relationships with Backend/Frontend and external SQL db

by: mariantrygg | last post by:

Hi I have a db that I have split into FE/BE but which also uses a dozen or so linked tables from a SQL Server db. I have linked the SQL tables to the FE *rather than link them to the BE then...

Microsoft Access / VBA

Relationships confusion

by: davegb | last post by:

I'm totally new to relational database design. My boss has asked me to create a database of information on the employees in our group. Seemed to me like a simple application to learn the ropes. A...

Microsoft Access / VBA

XmlDataDocument error with DataSet relationships set

by: Steve | last post by:

I have a dataset. I fill it with two recordsets from SQL queries. Tables are called tblPlanFYSpendingStage, tblSpendingStage.

ASP.NET

Relationships. Does anyone use them?

by: salad | last post by:

I'm curious about your opinion on setting relationships. When I designed my first app in Access I'd go to Tools/Relationships and set the relationships. Over time I'd go into the window and see...

Microsoft Access / VBA

Can attributes of tables/relationships, etc. be changed programatically?

by: Ron | last post by:

Hi All, Development stage of setting up a new solution here. I CONSTANTLY have to unhook the relationships I've built via the Relationships tab on Tools, then change the Required element of a...

Microsoft Access / VBA

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Is there any advantage to defining relationships for tables and queries

Similar topics