Traces of a table created by texis

[KMandalia]

What are the places references are added when a new table is created by a new profile being created?

For example, if I want to wipe out, say, querylog table, is dropping the table good enough? Or do I have to go to SYSTABLE and SYSINDEX and so on? If yes, what is the complete list?

Also, if I were to run random queries using texis where is the documentation that mentions what index is needed to run what type of query etc?

[mark]

Dropping a table is sufficient to clean up it's indices etc.

See "INDEXING FOR INCREASED PERFORMANCE"