compressed indexes

Does anybody know how to lower the number of levels in a btree index ? We have some that have 4 and 5 levels, and I read that is a performance hit. Thanks, ======================== -<<Floyd Wellershaus>>- Database Administrator Unix Administrator email: fwellers@yahoo.com Work: 703-733-4126 Pager: 703-705-9241 Email Pager: 7037059241@my2way.com Home: 703-430-0805 Cell: 703-477-6045 ========================

Floyd Have less rows in the table :-) Have less columns in the index :-)) Have larger pages :-))) Basically no, but you might like to investigate the index(es) to see if they can be rationalised (shortened). Keith -> -----Original Message----- -> From: Floyd Welle.... [mailto:fwellers@yahoo.com] -> Sent: Wednesday, December 29, 2004 12:07 PM -> To: ids@iiug.org -> Subject: compressed indexes [3930] -> -> -> Does anybody know how to lower the number of levels in a -> btree index ? -> We have some that have 4 and 5 levels, and I read that is a -> performance -> hit. -> -> Thanks, -> -> -> -> ======================== -> -<<Floyd Wellershaus>>- -> Database Administrator -> Unix Administrator -> -> email: fwellers@yahoo.com -> Work: 703-733-4126 -> Pager: 703-705-9241 -> Email Pager: 7037059241@my2way.com -> Home: 703-430-0805 -> Cell: 703-477-6045 -> ======================== -> -> -> ******************************************************************************** ** This message is sent in strict confidence for the addressee only. It may contain legally privileged information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise the sender immediately of any error in transmission. This footnote also confirms that this email message has been swept for the presence of computer viruses, however we cannot guarantee that this message is free from such problems. ******************************************************************************** **