Skip to Content
0
Jul 29, 2005 at 09:07 AM

Database statistics & Hints

97 Views

Hi,

I have few question regarding Database statistics & Hints.

1. I understand that after creating a database index, the database statistics for that table must be updated. Otherwise the optimiser will not detect the index. Can I overcome this using the database hints?

2. As far as I am aware of we are safe to create index for all transparant tables. Are there any restictions?

How about table VEPO?

The syntax I have used for hints is

%_HINTS ORACLE 'INDEX("VEPO~Z1")'

Hope this is correct.

Thanks in advance

Vinod