Please excuse my ignorance...but do you mean that I should join the
views into the query..? I'll have a look at that this evening...

I will also try to get the plan for you...but, as mentioned in my
previous post, it brings my computer to a near-halt for a _very_ long
time...

Either way, thanx for the tip..! :o) I'll try to get the information
to you as soon as possible...

-----Original Message-----
From: Aage Johansen [mailto:aagjohan@...]
Sent: 08 April 2004 15:31
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] FireBird : Table Setup, Views and Slow
Queries

On Thu, 8 Apr 2004 10:14:14 +0000 (UTC), Werner Cloete wrote:

> ...
> select PROPERTIES.AGENT_REFERENCE,
> OWNERS.SURNAME as OWNER_SURNAME, OWNERS.INITIALS as
> OWNER_INITIALS, OWNERS.NAME as OWNER_NAME, OWNERS.COMPANY_NAME as
> OWNER_COMPANY_NAME,
> BUYERS.SURNAME as BUYER_SURNAME, BUYERS.INITIALS as
> BUYER_INITIALS, BUYERS.NAME as BUYER_NAME, BUYERS.COMPANY_NAME as
> BUYER_COMPANY_NAME,
> PROPERTIES.ADDRESS_ROAD,
> 'xxxxx' as OUR_REFERENCE /*Calculated via another process*/,
> INSPECTIONS.DATE_INSPECTED,
> COMPANIES.ELECTRICAL_INSPECTION_COMM as COMMISSION
> from INSPECTIONS, PROPERTIES,
> PROPERTY_OWNERS, OWNERS,
> PROPERTY_BUYERS, BUYERS,
> PROPERTY_AGENTS, AGENTS,
> COMPANIES
> where INSPECTIONS.INSPECTION_ID = 23 and
> PROPERTIES.ID = INSPECTIONS.PROPERTY_ID and
> PROPERTY_OWNERS.PROPERTY_ID = PROPERTIES.ID and
> OWNERS.ENTITY_ID = PROPERTY_OWNERS.ENTITY_ID and
> PROPERTY_BUYERS.PROPERTY_ID = PROPERTIES.ID and
> BUYERS.ENTITY_ID = PROPERTY_BUYERS.ENTITY_ID and
> PROPERTY_AGENTS.PROPERTY_ID = PROPERTIES.ID and
> AGENTS.ENTITY_ID = PROPERTY_AGENTS.ENTITY_ID and
> COMPANIES.ID = AGENTS.COMPANY_ID
> ...



Use explicit joins here as well, and post the PLAN for the slow query.


--
Aage J.






Yahoo! Groups Links





This e-mail message is confidential and intended solely for the person to whom or the entity to which it is addressed. All the contents and any attachments remain the property of VR Services (Pty) Ltd unless so stated by contract.
If you are not the intended recipient, you are prohibited from reading, copying, using or disclosing this message to others.
If you received this message in error, please notify the sender immediately by replying to this e-mail or by telephoning +27 21 430 9300 and thereafter delete the message. VR Services (Pty) Ltd does not accept liability for any personal views expressed in this message.