It would really help me to see how long they’ve been inked up so I can figure out which pens have been inked up the longest…might be time to use it some more or clean it out.
dynamic sampling used for this statement Predicate Information (identified by operation id): | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | SQL> select object_name from d where upper(status)='T' Some tests then.SQL> set autotrace traceonly exp so Oracle will index the same pseudo column! Eureka! Thats the index bit, we got two indexes with the same "function", SQL> create index d_2 on d(object_id,upper(status),timestamp) SQL> select index_name,column_expression from user_ind_expressions
SQL> select index_name,column_name from user_ind_columns where table_name='D' Let's index it with some pseudo stuff.SQL> create index d_1 on d(upper(status)) SQL> create table d as select * from all_objects They are indeed pseudo-columns, or calculated columns as I think Oracle wants to call them in 11g. However, when playing around with some composite indexes including functions today I finally got it. Never thought much about investigating it either.
I never really understood the whole thing about it, sure I figures one could consider it a pseudo-column as it was sort of a calculated value that was stored in the database. All the cool people I meet at Oracle events keep referring to "function based indexes" as pseudo-columns.