Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
user71408
Starting Member
5 Posts |
 Posted - 2008-05-15 : 12:37:40
|
Hi all,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)Thanks in advance  |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-15 : 13:15:59
|
| Is this for oracle? |
 |
|
|
user71408
Starting Member
5 Posts |
Posted - 2008-05-15 : 13:24:32
|
| yes. It's related 2 Oracle |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-15 : 13:25:38
|
| This is a Microsoft SQL Server site, so it is unlikely you'll get Oracle answers. I'd suggest you post your question in an Oracle forum such as the one over at dbforums.com.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
user71408
Starting Member
5 Posts |
Posted - 2008-05-15 : 13:35:09
|
| is there any forum for ORACLE other than Oracle forum and ORAFAQ...pls let me know. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-15 : 13:37:33
|
| What is wrong with what I suggested?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 23:05:00
|
| >> is there any forum for ORACLE other than Oracle forum and ORAFAQ...google it. |
|
|
|
|
|
|
MultiThreading concept in oracle