Should I create a clustered index in a fact table? never? is always?

Question

In the data warehouse, are there any drawbacks to creating clustered indexes on fact tables? (most of the time it will be in the datetime column)

Did you answer yes or no by default ... ??

If I don’t need to create default clustered indexes, then why? (I know the pros of clustered indexes, but what are some of the downsides?)

References

http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2006/09/11/365.aspx

Answer 1

( ), . ( ) , , . ... ! , . , , , .

. , Lucene ( Lucene.NET). Lucene ( ), ( ), , . , , , ! ( FullText SQL Server). .

Answer 2

always never, , . , , . , - GUID. , .

, , , , , .

1.) , .

2.) , , , , . .

Answer 3

int (bigint) PK- ; . , , , .