LIST.INDEX hashedfile
Posted: Tue Mar 06, 2012 11:55 pm
All,
After seeing LIST.INDEX hashedfile, i have lot of question in my mind.
a) what are all the types of indexes supported by datastage? clustered or nonclustered. if both of them are supported, will it work as is in datastage too?
b) i am creating a external path hashed file. which index will be created by default? is there any option to add some more indexes ( say for example, create unique nonclustered index id1 on <tablename> ) once I created the hashed files?
c) how many indexes can be created for a hash file?
c) will LIST.REINDEX work like REORG command (db command) ?
Inputs are welcome!
After seeing LIST.INDEX hashedfile, i have lot of question in my mind.
a) what are all the types of indexes supported by datastage? clustered or nonclustered. if both of them are supported, will it work as is in datastage too?
b) i am creating a external path hashed file. which index will be created by default? is there any option to add some more indexes ( say for example, create unique nonclustered index id1 on <tablename> ) once I created the hashed files?
c) how many indexes can be created for a hash file?
c) will LIST.REINDEX work like REORG command (db command) ?
Inputs are welcome!