By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,665 Members | 1,900 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,665 IT Pros & Developers. It's quick & easy.

How to use collect statistics for temporary index?

P: n/a
Hi All

i used this statement to create a temporary table index.

Create index session.indname on session.tablename collect
statistics.

it throws an error saying that

SQL0526N The requested function does not apply to declared temporary
tables.
SQLSTATE=42995
I want to know any other option is there to do this?

Warm Regards
Guru

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.