Answer Posted / madhoo

Determinants are used for to improve the query performance

these are like .... 1. Computer system and network capacity
2. Schema design
3. Database objects
4. Best practices for writing queries
5. Physical storage layout
6. Parallel query and Red Brick Warehouse configuration

computer host loaded correctly and network traffic problem
should be overcome....
A well designed Schema has most effect on query performance...
Database object give good performance .....those are Indexes
and predefined objects...
There are so many ways to write query on a logic...but with
the help of best practices only we can write well
performanced query.
.........

Any question on cognos and Sql .....let me wake up for
them at Cognos.madhoo@gmail.com

Can you explain dynamic query mode?

581

---

What are the components of report net?

728

---

What is Metrics designer?

591

---

We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2078

---

New coloums are added in database, then how you know in report level

1151

---

---

Can you define cognos powerplay?

627

---

What is the use of report studio?

598

---

how to merge 2 crosstabs thans

2145

---

Can you define cube?

576

---

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

1483

---

Can you define drill down and drill up?

633

---

Can you define drill across?

560

---

What is looping and how to avoid it in framework manager?

657

---

What is Bitmap Index?

605

---

-----------------What is Direct and Conventional loading?

1641

---