Busy: This is the state that is used so that you can have the application open, but nevertheless, you do not receive any type of notification regarding messages or calls.Absent: This message means that a while ago, you stopped using the application, but, nevertheless, this does not mean that people stopped writing to you.For this reason, it is not surprising that the same app, after you have been active for 4 minutes, changes your status to recently active. Recently active: This is a special option, which is reflected in those people who use the application within their phone, so what people will see is the moment in which you stopped using the application very recently.Active: It means that the person you are trying to contact is online within the application, so you can make calls and messages without any problem.We can increase performance by making index in both two while connecting session we can change paratern of use of visible or invisible index. This case is used such as date time we need to use for transactional purpose and in night time we need to use for reporting purpose. We can use the invisible and visibile index by changing session parameters.

We can also create new index for testing purpose directly in invisible state and check index increase the performance of SQL queries then we make it in visible state.ĬREATE INDEX index_name ON table_name(column_name) INVISIBLE SQL> alter index test.sys_c008203 invisible SQL> select index_name,visibility from user_indexes Select index_name,visibility from dba_indexes where table_name = 'TESTPRIMARY' So, plan to make the index invisible for time period if our environment need the index we will make it visible by alter its property.ĪLTER INDEX schema_name.index_name INVISIBLE ĪLTER INDEX schema_name.index_name VISIBLE Ĭheck the visible or invisible index present on table Table having large in size if we need to create again the dropped index then we need large time. Help in performance, We want to drop the index from the production server but we did not know the effect after drop. Alter make index invisible or visible in Oracle

Skype sign in as invisible