[AccessD] Query Run time in different databases

Kaup, Chester A kaupca at ChevronTexaco.com
Wed Apr 16 13:55:50 CDT 2003


The tables are attached Oracle table so you would think that the indexes
and primary keys would be the same in both databases. Wrong! Correcting
indexes and primary keys fixed the problem Thanks.
 
-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: Wednesday, April 16, 2003 11:44 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Query Run time in different databases


Do both dbs have the same tables with the same indexes on them?  If the
second db is missing an index that the query uses, then it may be forced
to do a table scan which is much slower for large tables.  If that is
not the problem, then you will have to give us more information about
these two dbs.
 
 

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 

-----Original Message-----
From: Kaup, Chester A [mailto:kaupca at ChevronTexaco.com] 
Sent: Wednesday 2003 Apr 16 11:22
To: accessd at databaseadvisors.com
Subject: [AccessD] Query Run time in different databases



I have a query that takes about 10 seconds to run in one database. I
copied the query into another database using the menu bar. The query
tries to run for hours in the database it was copied into. The original
database is larger if that matters. A compact and repair seemed to have
no effect. Any thoughts as to what is happening?

No trees were killed in the sending of this message. However a large
number of electrons were terribly inconvenienced.



-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030416/e0ce3032/attachment-0001.html>


More information about the AccessD mailing list