Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: myworldntl
- Order by date
-
Oracle 8 Performance tuning question
Not too sure about this bit though: " Have you confirmed that all of the column expressions that are operands in an equijoin ('=') in your WHERE clauses are expressions in indexes? " Dont follow/understand this bit? Thanks :-)- myworldntl
- Post #4
- Forum: Oracle: All versions
-
Oracle 8 Performance tuning question
Problem is i guess that we only have oracle 9i and 10g at work and the customer runs 8i, so there are optimizer differences... However, (the first block of SQL) runs in 15 minutes on 9i, but can take up to an hour and a half or more on the customer site... So i would have thought that with...- myworldntl
- Post #3
- Forum: Oracle: All versions
-
Oracle 8 Performance tuning question
Hi there, i have been given some SQL at work that is taking forever to run client side. The first version of the SQL statment is the block i was given which i have already altered and performs better and returns the correct data still, just is still too slow. The second block is the SQL i've...- myworldntl
- Thread
- Replies: 4
- Forum: Oracle: All versions
