Answer / thanjairajan@gmail.com

The WITH clause may be processed as an inline view or resolved as a temporary table. The advantage of the latter is that repeated references to the subquery may be more efficient as the data is easily retrieved from the temporary table, rather than being requeried by each reference.

For example:

WITH dept_count AS (
SELECT deptno, COUNT(*) AS dept_count
FROM emp
GROUP BY deptno)
SELECT e.ename AS employee_name,
dc.dept_count AS emp_dept_count
FROM emp e,
dept_count dc
WHERE e.deptno = dc.deptno;

Answer / krishna

Specifies whether to send a request to the database using
an SQL WITH clause. When set to Yes, and if the database
supports WITH clauses, a WITH clause request is generated.
When set to No, or if the database does not support WITH
clauses, a request using derived tables is generated

Types of Performance Tuning?

2 Answers   CGI,

---

what is logs in cognos

1 Answers   Target, Thomson Reuters,

---

whats the difference between previous version of cognos and cognos 8 BI?

1 Answers   IBM,

---

Why is auto-regression used in forecasting used on cognos platform?

0 Answers  

---

how can you create a project creation

0 Answers   HSBC,

---

How to connect three fact tables?

11 Answers   L&T, TCS,

---

-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?

1 Answers   IBM,

---

what is the use of macros&folders&herarchies in frameworkmanger?

1 Answers  

---

suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???

3 Answers   CTS, iFlex,

---

How can I test reports in cagonos?

0 Answers  

---

What is drill down and slicing and dicing whats the difference between them?

0 Answers  

---

what are the uses of report studio,q.studio,analysis studio,event studio&.metric studi.

2 Answers  

---