Create Index in Sql 7.0 column's view

[prpnovaes]

I have a big view in a SQL Server 7.0 Database (mounted using 5 tables having clustered indexes), that returns
too much lines.

As I can't use ORDER By clause in the select statement at the view's creation (timeout problem), and I need to access the lines in a specific order, I would like to know if is it possible to create an index(clustered or nonclustered) under a SQL Server 7.0 column's view ?

If possible, how can i do it? In SQL Server 2000, it's possible with the create index command. But in the SQL Server 7.0 version...?

Could you help me?

Thanks.

 

[RickCole]

Unfortuantly you can not create an index on a view in SQL Server 7.0. It was something they added in SQl Server 2000.

Rick.