Home » SQL & PL/SQL » SQL & PL/SQL » Avoiding Full table Scans (Oracle 10g, Windows XP)
Avoiding Full table Scans [message #335995] Thu, 24 July 2008 06:07 Go to next message
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 #335999 is a reply to message #335995] Thu, 24 July 2008 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
which I believe is the culprit,

Why?

Is your statistics up to date?

You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide

Then provide the requested and usual information.

Regards
Michel
Re: Avoiding Full table Scans [message #336123 is a reply to message #335999] Thu, 24 July 2008 22:35 Go to previous messageGo to next message
rleishman
Messages: 3724
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 Go to previous messageGo to next message
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
Re: Avoiding Full table Scans [message #336144 is a reply to message #336135] Fri, 25 July 2008 00:41 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
[quote title=Michel Cadot wrote on Thu, 24 July 2008 13:38]
Quote:
...
You can first read:
- OraFAQ Forum Guide, Performance Tuning section
- How to Identify Performance Problem and Bottleneck
- OraFAQ Performance Tuning
- Rosco's SQL Tuning Guide


Regards
Michel

Previous Topic: Date Range
Next Topic: Catalogs in oracle?
Goto Forum:
  


Current Time: Tue Dec 06 15:48:11 CST 2016

Total time taken to generate the page: 0.10537 seconds