|
|
| Binu abraham 2002-11-11, 10:24 am |
| Hi
I created an index on a bit column .Actually bit column takes only 1 byte to
store the data.The each row size of the index is around 28 bytes. That means
27 bytes is used to store rowid or some kind of info ???
Am I right?? . Why it's taking that space ?? What's stored in that huge
space ??
..Actually by adding 3 indices the space used by table doubled ..
Is there any way to reduce the storage size of indices
Thanks in
| |
| Stefan 2002-11-11, 10:24 am |
| Do you really need an index on a column with only 2 possible values ? The
query engine won't use it anyway because of it's distribution. The updates
and inserts will be slower, so I would drop it.
"Binu abraham" <abraham@synygy.com> wrote in message
news:en5vAmZiCHA.1676@tkmsftngp08...
> Hi
> I created an index on a bit column .Actually bit column takes only 1 byte
to
> store the data.The each row size of the index is around 28 bytes. That
means
> 27 bytes is used to store rowid or some kind of info ???
> Am I right?? . Why it's taking that space ?? What's stored in that huge
> space ??
>
> .Actually by adding 3 indices the space used by table doubled ..
> Is there any way to reduce the storage size of indices
>
> Thanks in
>
>
| |
| Binu abraham 2002-11-11, 10:24 am |
|
Binu abraham wrote in message ...
Change in message it's not bit an integer,and char(41) columns
Hi
I created an index on a bit column .Actually int column takes only 4 byte
to
store the data.The each row size of the index is around 30-31 bytes. That
means
27 bytes is used to store rowid or some kind of info ???
Am I right?? . Why it's taking that space ?? What's stored in that huge
space ??
Actually by adding 3 indices the space used by table doubled ..
Is there any way to reduce the storage size of indices
Thanks in advance
| |
| Tony Rogerson 2002-11-11, 10:24 am |
| The clustering key is stored in all non clustered indexes - if you clustered
on a 50 byte column then all non clustered indexes would contain that 50
byte column also - this is known as a bookmark. For a table without a
clustered index, a pointer based on the file number and other bits is used.
--
Tony Rogerson SQL Server MVP
Torver Computer Consultants Ltd
http://www.sql-server.co.uk [UK User Group, FAQ, KB's etc..]
http://www.sql-server.co.uk/tr [To Hire me]
"Binu abraham" <abraham@synygy.com> wrote in message
news:en5vAmZiCHA.1676@tkmsftngp08...
> Hi
> I created an index on a bit column .Actually bit column takes only 1 byte
to
> store the data.The each row size of the index is around 28 bytes. That
means
> 27 bytes is used to store rowid or some kind of info ???
> Am I right?? . Why it's taking that space ?? What's stored in that huge
> space ??
>
> .Actually by adding 3 indices the space used by table doubled ..
> Is there any way to reduce the storage size of indices
>
> Thanks in
>
>
|
|
|
|