Run fast query

[ootkhopdi]

HI
I am running a query in my data base which having records more than 1 lacs..
when i open a query to place codes of field values.. it runs very very slow.. in app.15 mins.

how can i run it fast.?
is any temp table help me ?
if yes then how ?

please help me...

 

[CJ_London]

difficult to suggest anything without knowing what you are doing.

Main requirements are

tables are normalised
avoid union queries (usually implies unnormalised data)
ensure all fields used in relationships and criteria are indexed
don't use domain functions (dsum etc)
don't use the initial * in string criteria ( somefield Like *something*)
use subtables and join rather than subqueries in criteria wherever possible

 

[The_Doc_Man]

I don't know what "more than 1 lacs" means.

To have ANY clue as to how to help you, we would need to know something about the query and something about the table layout. Otherwise, your question is total open-ended and unanswerable in its current form.

 

[ootkhopdi]

I don't know what "more than 1 lacs" means.

To have ANY clue as to how to help you, we would need to know something about the query and something about the table layout. Otherwise, your question is total open-ended and unanswerable in its current form.

My means is Number of records in table are more than 10 millions..(>100000)

 

[ootkhopdi]

difficult to suggest anything without knowing what you are doing.

Main requirements are

tables are normalised
avoid union queries (usually implies unnormalised data)
ensure all fields used in relationships and criteria are indexed
don't use domain functions (dsum etc)
don't use the initial * in string criteria ( somefield Like *something*)
use subtables and join rather than subqueries in criteria wherever possible

I am running a query to sort, and giving code to a field from other table...
it this query no sum, no *, but it runs very slow

 

[CJ_London]

I am running a query to sort, and giving code to a field from other table...

sorry - means nothing to me.

it this query no sum, no *, but it runs very slow

And what about all my other suggestions - to which you can add the field(s) you are sorting on should also be indexed.

 

[jdraw]

ootkhopdi,

Can you tell us again in simple terms what you are trying to do ? As others have said, your post is not clear. Either tell us in detail or give us an example of input and expected output. Readers can not help you until they understand the issue.

 

[static]

My means is Number of records in table are more than 10 millions..(>100000)

That's 100 thousand. If you really mean > 10 million you shouldn't be using Access. Especially from a network.