No rows in PROJECTION_COLUMNS after ANALYZE_STATISTICS

Hi ,

Could some one help me solve the below problem :

I ran

focus_owner=> SELECT ANALYZE_STATISTICS('focus.fixture_details.Fixture_Id' ) ;
ANALYZE_STATISTICS
--------------------
0

focus_owner=> select * from PROJECTION_COLUMNS WHERE table_name ='focus.fixture_details' ;
(No rows)

Why even after collecting stats on a column for a table the PROJECTION_COLUMNS gives no rows .

Thanks in advance .

Priyabrat

+1

Hi,

Does a projection exist for the table fixture_details? Did you create one?

-Regards,

Sruthi

+2

In the table you don't need to put the schema, there is a separated field for the schema

focus_owner=> select * from PROJECTION_COLUMNS WHERE table_name ='focus.fixture_details'

try like this

select * from PROJECTION_COLUMNS WHERE anchor_table_name ilike '%fixture_details%'

Hope this helps.

Eugenia

Thanks , its working now .

Sign up