Please let me know the details of the following.
1.What is Multi-Threading?
2. How it is useful to increase the Performance of a SQL query.( How it is useful
in Optimizing the query.
3. How we'll use MultiThread concept in Partitions and Using Processors.( For Eg.. If I want to use MAX threads=14 and 16 processors in this situation how we use PArtition concept and how it will improve the bufffer size of the CPU)

Before using Multithreading concept PCTused is 90% then it will effect performance of the query ..am I right?
So if we use Multithread concept we can increase the PCTfree means used is 75% and Memory buffer is 25% but before we have only 10% of free space..

I know theoritically but I don't know practically.Can u explain it pls..

Hi all,
I used Max threads=12 and 16 processors(files) with partitions for SQL query for improving the performance.How Multithread concept will work with this Processors when we partitioned the se files.
eg: we have 12 threads.
Threads : 1 2 3 4 ..... 12

Files : 1 2 3 4 .......12
13 14 15 16

if we partitioned like it will improve the performance of the quer...( this works fine in my situation...)

I know it will work like this.then my doubt is I know theoretically. can any one please explain me practically how it works?

the performance of the query is not good.So I want to use Multithread (Multi-processor) concept to increase the performance.for Eg : I have 8 processors and 6 threads.If I execute these 8 processors in the 6 threads then performance will become good..(am I right? it's my opinion...)
if it works how it works?please let me know..

The item_sale.ksh module takes 30 minutes (on average) to complete. This script is on the AIM batch release critical path and currently runs too long. We need to tune this script to ensure that we minimize the delay in releasing the AIM batch.

So I am going to resolve this issue using the posted script.
SO I want to understood what it is doin exactly..Then hope I can resolve this issue...So please explain me the issue.

I don't know if you are talking to Ana or me (as you called Ana, Michel) but for myself I will not spend time to try to understand YOUR code, espcially when you don't give the whole informations that allow me to understand.