Re: how do I get dbspace for index

abeylin@yahoo.com wrote 1 Sep 99, 15:20: > Hello all and thaks for trying to answer my message. > > Please tell me how I can find out on which dbspace an index is > created. I need to do this from a C program, thus I need to know the > SQL statements I need to execute, I do not want to run dbschema and > parse it's output. My boss will kill me if I do it that way. > > I found out how to get dbscpace for a table, so please don't send me > instructions on how to do that. > > Looking forward to seeing your answers/suggestions. > Thanks. > Alex > > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't. The index of a table resides, by default, in same dbspace of the table. (use dbinfo function to know in what dbspace reside the table). That's true except if you use fragmentation. In this case the index's location will be knowledged using the information of sysfragments. Ps. Advance to your boss killing him. ;-DDDD --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------