468,139 Members | 1,457 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,139 developers. It's quick & easy.

How to find indexes working on a temporary table in UDB AIX.(UDB 8.1)

Hi Everybody,
We are using UDB v8.1
I will explain about my Stored procedures which we are executing in
UDB AIX box. We have 3 millions(apporox) of data in 22 tables. By
applying the business logic through Stored procedures on 22 tables and
writing into 3 new tables. We have used all temporary tables except
starting 22 tables. The Stored procedures we have used nearly 6
temporary tables to handle the business logic. Finally we are loading
into 3 permanent tables. For processing the above 3 million records it
took 29 hours, which should not happened to take that much time. We
are not able to find whether indexes which we have created on
temporary tables are working or not. We have tuned the same Stored
procedure and run in NT box for 1 lakh records it was executed in 6
min.
Can anybody will give a command to find whether indexes are working or
not? and one more question what is the limit, for which indexes will
work on temporary tables?
I will appreciate, if I get the solution as soon as possible. We are
in deep trouble. Please help me on this.

Thanks and Regards,
Sampath Reddy G.
Chennai - india
Nov 12 '05 #1
1 2387

"Sampath Reddy" <gs********@yahoo.com> wrote in message
news:4f**************************@posting.google.c om...
Hi Everybody,
We are using UDB v8.1
I will explain about my Stored procedures which we are executing in
UDB AIX box. We have 3 millions(apporox) of data in 22 tables. By
applying the business logic through Stored procedures on 22 tables and
writing into 3 new tables. We have used all temporary tables except
starting 22 tables. The Stored procedures we have used nearly 6
temporary tables to handle the business logic. Finally we are loading
into 3 permanent tables. For processing the above 3 million records it
took 29 hours, which should not happened to take that much time. We
are not able to find whether indexes which we have created on
temporary tables are working or not. We have tuned the same Stored
procedure and run in NT box for 1 lakh records it was executed in 6
min.
Can anybody will give a command to find whether indexes are working or
not? and one more question what is the limit, for which indexes will
work on temporary tables?
I will appreciate, if I get the solution as soon as possible. We are
in deep trouble. Please help me on this.

Thanks and Regards,
Sampath Reddy G.
Chennai - india

Capture the access plan you could find out if the temporary table use
indexes or not. I never did this. But I remembered I ever asked this
question and the instructor did the test and told me the result.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Troels Arvin | last post: by
2 posts views Thread by UnixSlaxer | last post: by
5 posts views Thread by bughunter | last post: by
16 posts views Thread by romicva | last post: by
2 posts views Thread by alex.mcshane | last post: by
27 posts views Thread by didacticone | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.