SQL Performance (MOSC)

MOSC Banner

Hi, Do I realy have to have global statistic on a table and on its virtual columns if I have statist

edited Mar 9, 2016 11:36AM in SQL Performance (MOSC) 7 commentsAnswered

Hi,

I have a table with an XML column. Right now column has 120 FBI and this will just get worse..

I was wondering if I realy need the statistics on the virtual columns if I have them on the FBI?

and do I realy need global statistic on the table?

Thanks in advanced,

Vered

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center