SQL query _slow_

Поиск
Список
Период
Сортировка
Искать
От
Gregg Berkholtz
Тема
SQL query _slow_
Дата
Msg-id
36D09076.A762A525@gbcomputers.com
Список
Дерево обсуждения
Re: [SQL] SQL query _slow_ Gregg Berkholtz <gregg@gbcomputers.com>
Re: [SQL] SQL query _slow_ Bruce Momjian <maillist@candle.pha.pa.us>
I have a few SQL query's that are taking in the range of 30-60 seconds
to complete. They are searching tables that are no larger than 120 rows
with I believe 7 columns of data each.
Any ideas?
The SQL statement is below:

SELECT tblClientInfo.fName, tblClientInfo.lName, tblClientInfo.phoneNum,
tblClientLocation.locationName, tblTroubTick.TroubTickLastUpdate,
tblTroubTick.hoursInvested, tblSupportPersInfo.fName,
tblSupportPersInfo.lName, tblPriority.priority, tblTroubTick.assetID,
tblTroubTickStatus.troubTickStatus, tblTroubTickProblem.troubTickProblem

FROM tblClientInfo, tblTroubTick, tblClientLocation, tblSupportPersInfo,
tblPriority, tblTroubTickStatus, tblTroubTickProblem
WHERE  tblTroubTick.troubTickStatusID <> 7 AND
tblClientLocation.locationID = tblClientInfo.locationID AND
tblTroubTick.clientID = tblClientInfo.clientID AND
tblTroubTick.supportPersID = tblSupportPersInfo.supportPersID AND
tblTroubTick.priorityID = tblPriority.priorityID AND
tblTroubTick.troubTickStatusID = tblTroubTickStatus.troubTickStatusID
AND tblTroubTick.troubTickProblemID =
tblTroubTickProblem.troubTickProblemID;

Thanks for any help!
Gregg Berkholtz

В списке pgsql-sql по дате отправления
От: George Henry C. Daswani
Дата:
Сообщение: HAVING confusion..
От: Bruce Momjian
Дата:
Сообщение: Re: [SQL] SQL query _slow_
FAQ