Answer Posted / Shripal
OLTP (Online Transaction Processing) systems are designed for handling multiple, short transactions with low latency. They often use clustered indexes and store data in a normalized form to optimize insert, update, and delete operations. OLAP (Online Analytical Processing) systems, on the other hand, focus on complex queries and analysis of large amounts of data. They typically use denormalized schema and materialized views to optimize query performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is subquery? Explain the properties of a subquery?
Can one drop a column from a table?
What kind of problems occurs if we do not implement proper locking strategy?
How to enter binary string literals in ms sql server?
Can sql servers link to other servers like oracle?
What are wait types?
How do I create a trace in sql server?
Does view occupy space?
What are different types of constraints?
What is the difference between for xml raw and for xml auto?
Can we do dml on views?
How can I check that whether automatic statistic update is enabled or not?
What are the kinds of subquery?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Why and when do stored procedure recompile?
