multi-field query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

thread - 15 Mar 2007 08:41 GMT

Hi all,
I have a select query that consist alot of tables and fields,that
issue is making the proccess heavier
is it posible to make it faster then its current stage?otherwise i
need to run a make-table query that will build a table but this
proccess will blow the file size
any ideas?

Reply to this Message

Joseph Meehan - 15 Mar 2007 12:36 GMT

> Hi all,
> I have a select query that consist alot of tables and fields,that
[quoted text clipped - 3 lines]
> proccess will blow the file size
> any ideas?

I doubt if making a new table is going to help you, but without knowing
a lot more about your current design I don't think anyone can really guess.

Signature

Joseph Meehan

Dia 's Muire duit

Reply to this Message

thread - 15 Mar 2007 14:09 GMT

it accually helps becaouse its just taking data from one table and
when its pulling data its just using one table data instead of 10-12
tables in a query

Joseph Meehan כתב:

> > Hi all,
> > I have a select query that consist alot of tables and fields,that
[quoted text clipped - 11 lines]
>
> Dia 's Muire duit

Reply to this Message