Avoiding Full table Scans [message #335995] |
Thu, 24 July 2008 06:07  |
freakabhi
Messages: 74 Registered: November 2007 Location: mumbai
|
Member |
|
|
Hi all,
I am facing problem of query performance with my SQL,
I saw the expalin plan and found there are around 10 full tables scans, which I believe is the culprit,
I tried to find the performance tips for this issue on NET, but could not found it so far, this is sample for one of the subquery we have, I am not sure looking at the SQL only how much one can help,
but may be if somebody give me some important links or something like that, it will be of g8 help.
SELECT t.id, tlk.ty,count(*)
FROM t, tlk
WHERE t.id = tlk.id
GROUP BY t.id, tlk.ty
thanks,
freakabhi
|
|
|
|
Re: Avoiding Full table Scans [message #336123 is a reply to message #335999] |
Thu, 24 July 2008 22:35   |
rleishman
Messages: 3728 Registered: October 2005 Location: Melbourne, Australia
|
Senior Member |
|
|
To borrow a favourite metaphor, you bring us the steering wheel and ask "What's wrong with my car?".
How much do you think we can help with just seeing a sub-query.
Read the sticky (first post in this forum) and the forum guidelines. They will tell you what we need.
Ross Leishman
|
|
|
Re: Avoiding Full table Scans [message #336135 is a reply to message #336123] |
Fri, 25 July 2008 00:09   |
freakabhi
Messages: 74 Registered: November 2007 Location: mumbai
|
Member |
|
|
thanks for replying,
but the same thing I even mentioned, and I was looking for general tips not the query specific tips.
So anything in general you have, can u mention.
from,
Freakabhi
|
|
|
|