What is mean by "fill factor" ? and what is mean
by "Index "in sql?
- 1 Answers
- 8729 Views
- iGate, Logica CMG, I also Faced
- E-Mail Answers
Answer Posted / gunjan sapra
fill factor is a defiened percentage between 0 to 100 in
which we leave exra gaps to accomodate future expansions in
the storage of the futures data.
indexing in sql is same as the index in our books. it helps
us to manage our data more appropriately.it can be done in
two ways namely clustered index and non-clusterd index.
we can create only one clustered index per table and
maximum of 249 non-clustered indexes per table.
| Is This Answer Correct ? | 15 Yes | 6 No |
Post New Answer View All Answers
What do you think of this implementation? Can this be implemented better?
What new data source types were added in ssrs 2014?
Explain the difference between cross join and full outer join?
What are pages and extents? : SQL Server Architecture
What is data block and how to define data block size?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
How much does sql server 2016 cost?
Explain the use of containers in ssis and also their types?
What are the results of running this script?
How do I perform an unattended install of sql server 2000?
When would you use a before or after trigger?
How to use copy and concatenate commands in SQL?
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
How do clustered indexes store data?
Explain about system database?
