Explain what are partitioned views and distributed partitioned views?
- 1 Answers
- 1066 Views
- I also Faced
- E-Mail Answers
Answer Posted / Rajesh Tejan
{"partitioned_views": "A partitioned view is a type of SQL Server view that spans multiple partitions within a table or indexed view. It allows for better performance by reducing the amount of data that needs to be read during queries.",n "distributed_partitioned_views": "A distributed partitioned view is a type of SQL Server view that spans multiple tables, each of which is stored on a different server in a distributed database. It allows for better performance by distributing the workload across multiple servers."}
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you index views?
Why and when do stored procedure recompile?
How to connect php with different port numbers?
Explain “row_number()” in sql server with an example?
What are the properties of the transaction?
What are wait types?
How to convert numeric expression data types using the cast() function?
What is a scheduled job or what is a scheduled task?
Can sql servers link to other servers like oracle?
List out the different types of locks available in sql server?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Disadvantages of the indexes?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
