Urgent and detailed? This is a voluntary list. Urgent and detailed you can get from buying premium support from IBM. Particularly for a large organization such as InfoSys. What's more, the answer to your question, in huge detail, is in the manuals and in the on-line help.
A secondary index is used to speed queries that are constrained on a particular column or set of columns (fields). Any benefit to be gained by having indexing on columns must be weighed against the cost of keeping them up to date, even though this is automatically managed by the engine. In UniVerse secondary indices are created with the CREATE.INDEX verb. Do not attempt to index time-variant virtual columns. An index that is no longer required may be removed with DELETE.INDEX. If the file is a UniVerse table, the SQL statements CREATE INDEX and DROP INDEX should be used in preference. If there are already data in the file when CREATE.INDEX is used, BUILD.INDEX must be used to populate the index. LIST.INDEX reports on how a file is indexed, optionally with statistics and detail of indexed values. By default, indices are maintained by the engine. DISABLE.INDEX disables the automatic update of indices; ENABLE.INDEX enables it; UPDATE.INDEX applies any updates to indices that result from a period of updates to the base table while in deferred mode, by effecting a BUILD.INDEX command. SET.INDEX reports on and modifies information in the file header relating to location of the index/indices for the file. ----- Original Message ----- From: "Amit Bhutani" <[EMAIL PROTECTED]> Date: Wed, 19 May 2004 15:10:57 +0530 To: <[EMAIL PROTECTED]> Subject: [U2] Need Help on INDEX in universe > Hi group, > > Can any body let me know about the INDEX, y to use it and what are the > benefits of using it. What is the importance of LIST.INDEX, SET.INDEX, > CREATE.INDEX, BUILD.INDEX, DISABLE.INDEX commands. I think they are to > speed up the search. > > Please reply me asap. Need urgent and detailed answer.. > Thanks > Amit > ------- > u2-users mailing list > [EMAIL PROTECTED] > http://www.u2ug.org/listinfo/u2-users ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
