adspace
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
What is the current version of sql?
Is inner join faster than left join?
What is the best sql course?
What is the current version of postgresql?
what are aggregate and scalar functions? : Sql dba
Can we rollback truncate?
what are all the common sql function? : Sql dba
what is bcp? When does it used? : Sql dba
what is collation? : Sql dba
Can delete statement be rollbacked?
what is sql server agent? : Sql dba
Is primary key always clustered index?
how to use regular expression in pattern match conditions? : Sql dba
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
how many tables will create when we create table, what are they? : Sql dba