adspace


What is a table partition?

Answer Posted / Satti Devi

A table partition in SQL refers to dividing a large table into smaller, more manageable parts (or partitions) based on one or more columns. This improves performance by reducing the amount of data accessed during queries, index creation, and maintenance operations.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the current version of sql?

1106


Is inner join faster than left join?

1287


What is the best sql course?

1062


What is the current version of postgresql?

1188


what are aggregate and scalar functions? : Sql dba

1142


Can we rollback truncate?

1083


what are all the common sql function? : Sql dba

1141


what is bcp? When does it used? : Sql dba

1065


what is collation? : Sql dba

1242


Can delete statement be rollbacked?

1065


what is sql server agent? : Sql dba

1188


Is primary key always clustered index?

1101


how to use regular expression in pattern match conditions? : Sql dba

1125


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2099


how many tables will create when we create table, what are they? : Sql dba

1154