Interested to Buy Any Domain ? << Click Here >> for more details...
can anyone help me ? an index has been done on the primary
key of a table. an update operation was performed on that
table. now my question is 1> what abt the performance ?
means faster or slower due to indexing ? 2> does the
operation affect to the primary key constraint ?
normally database take to refresh time 2 hours. but client
asked iwant to refresh with in 5 min that same database. do
you have any option in BO and Oracle? explain me briefly...kavi
- 2 Answers
- 5392 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / janardhan.g
when we use an INDEX..performance will increases.........
Infact the main purpose of index is to increase the
performane only...(very fast).
2.the index ,genarally works based on primary key or unique
key.
when we use index..refreshing time will reduces..
ITS a database question...its no way related to BO.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is aggregate table and aggregate fact table ... Any examples of both?
any difficulitis have you phase while creating bo reports and how did u solve it
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
What Is The Difference Between Oltp And Olap?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
When we use aggregate awareness function in designer?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
Difference between b.o 5.1 and 6.1b?
What we need to discuss with designer before starting the universe designing.
What is the difference between user and versatile user?
Difference between zabo and webi?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
