Home » RDBMS Server » Performance Tuning » Index scans
Index scans [message #64660] Wed, 17 December 2003 23:07 Go to next message
Vinod Nair
Messages: 6
Registered: December 2003
Junior Member
1. In which way do Oracle uses different indexes?
2. In which conditon index fullscan,table access full,index fast fullscan used? because sometimes it uses table access full instead of index full or fast full

2. In which condition each of the merge join,hash join,nested loops used.


3. Tell me more about hash join in details

4. Please suggest about better sites for this type of information.
Re: Index scans [message #64661 is a reply to message #64660] Wed, 17 December 2003 23:21 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

All your questions are answered in chapter 1 of the "Oracle9i Database Performance Tuning Guide and Reference". Please read it first, if you still have questions, you are welcome to post them here.

Best regards.

Frank
Re: Index scans [message #64662 is a reply to message #64661] Thu, 18 December 2003 01:02 Go to previous messageGo to next message
Vinod Nair
Messages: 6
Registered: December 2003
Junior Member
I don't have the books suggested by u
So kindly try to reply my question.
Re: Index scans [message #64663 is a reply to message #64662] Thu, 18 December 2003 01:28 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

All Oracle's manuals are available on-line at http://otn.oracle.com/. You may need to register for an account, but membership is free.

Best regards.

Frank
Previous Topic: Cost, Card, Bytes
Next Topic: Improve the performance of an Oracle Query
Goto Forum:
  


Current Time: Thu Mar 28 11:05:54 CDT 2024