Re: Informx-SE (7.13) Basic DBA question

In article <3540F8C8.66C334AE@yahoo.com>, Asim <aaBubba@yahoo.com> writes >If I issue : >CREATE INDEX INDEX_NAME ON TABLE_NAME(COL_NAME) >command, would this be a Clustered Index or Non-Clustered ??> Non-clustered. Use CREATE CLUSTER INDEX INDEX_NAME ON TABLE_NAME(COL_NAME); ^^^^^^^ to create a clustered index. >TIA > >-asim > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care