Archives of the TeradataForum

Message Posted: Mon, 10 May 2004 @ 18:04:20 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Monday, May 10, 2004 13:01 -->

Hi,

I have a table with 250 million rows, and Im using ReportNet to display the output. It takes ages to display. So someone told me to use JOIN INDEX . Actually I dont know much about this subject. So could any one educate me on this subject :

a. Documents on Join Index

b. Advantages

c. Does it physically occupy space

d. How does it get refreshed

e. Can I partition

TIA

	<Prev	Next>		<<First	<Prev	Next>	Last>>