<HTML><HEAD></HEAD>
<BODY
style="FONT-FAMILY: Calibri, sans-serif; WORD-WRAP: break-word; COLOR: rgb(0,0,0); FONT-SIZE: 14px; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space"
dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Verdana'; COLOR: #000080; FONT-SIZE: 12pt">
<DIV>Firebird V2</DIV>
<DIV> </DIV>
<DIV>I have a large table (5,500,000+ records) that I just added an index to to
speed some queries. So far it has not made much difference – is the
existing data indexed immediately on creating the index?</DIV>
<DIV> </DIV>
<DIV style="FONT-FAMILY: 'Verdana'; COLOR: #000080; FONT-SIZE: 12pt">John
Bird<BR></DIV></DIV></DIV></BODY></HTML>