Hi,
may i know how to manually create an index in Universe Table ?[:(]
Appreciate your kind attention[:D]
Manual Create index in Universe Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How you create a secondary index on a hashed file/UV table depends on how it was created.
(1) If it was created with a CREATE TABLE statement (SQL), then you use the SQL statement CREATE INDEX, which has a conventional SQL syntax.
(2) If it was created with a CREATE.FILE statement (that is, in an account), then you use the CREATE.INDEX commmand (note the period).
CREATE.INDEX hashedfilename columnname
This can only create a single-column index.
(3) If it was created with a mkdbfile command (that is, in a directory), then you need to create a VOC pointer to the hashed file using the SETFILE command (search for this in the archives) then proceed as in (2) above.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
(1) If it was created with a CREATE TABLE statement (SQL), then you use the SQL statement CREATE INDEX, which has a conventional SQL syntax.
(2) If it was created with a CREATE.FILE statement (that is, in an account), then you use the CREATE.INDEX commmand (note the period).
CREATE.INDEX hashedfilename columnname
This can only create a single-column index.
(3) If it was created with a mkdbfile command (that is, in a directory), then you need to create a VOC pointer to the hashed file using the SETFILE command (search for this in the archives) then proceed as in (2) above.
Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: