Posted by Matik on 09/09/05 04:55

Hello 2 all,

Thank You for response. Hugo, additional explenation: I posted just a
part of view acctualy, in normal, it uses at the end pre defined order
by. To use order by in a view, you need to specify a top :(

John: I was wondering also ... but the explenation was easy: because of
historical reasons ;) For me it is also more or less obvious, that
storing data in separate collumns (specialy by long strings, and lot's
of data) is much more efficiency, that concentrated (specialy by this
scans).

You're right, that I do not expect so much rows in my table, I don't
acctualy know, why they integrated this collumn, but I need to keep it
(i think, they are using it for replication).

Primary key is set up on CID collumn (is not clustered with fill factor
on 90%). I dont know why the script didn't included the statement :(

I think, your idea is great, I was thinking acctualy exactly in this
way, I just need to be sure, from someone with expirience.

Thank You very much

Mateusz

[Back to original message]