What is a stretch database?



What is a stretch database?..

Answer / Sohan Singh

Stretch Database is a feature in SQL Server that allows certain tables to be automatically sharded across multiple storage tiers. It helps manage very large tables by keeping only hot data on the faster storage tier, improving query performance.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Database Management Interview Questions

What is openedge workgroup rdbms?

1 Answers  


What are procedures in dbms?

1 Answers  


Segregate database technology's development.

1 Answers  


Why do we need database management?

1 Answers  


Write a note on File based system/ Data base system

2 Answers  


What is the use of SHOW option in IMP command ?

1 Answers  


Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ?

1 Answers  


Explain the syntax of named procedure?

1 Answers  


What do you understand by sub-queries in sql?

1 Answers  


How to migrate paradox, dbase or foxpro database to firebird?

1 Answers  


What do you understand by data independence? What are its two types?

1 Answers  


What does DLL stands for ?

2 Answers   Nexus Technologies,


Categories