Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sys »View: x$schema_tables_with_full_table_scans
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - ... This view has at least this number of rows. Please refer to documentation. (Query took 0.0104 seconds.)
SELECT * FROM `x$schema_tables_with_full_table_scans`
object_schemaobject_namerows_full_scannedlatency
simpedak_db sidokaf_accreditation_institution_document 1528289 3647338334111
simpedak_db sidokaf_accreditation_transaction 1071988 536654813344
material-teknik permintaan 300004 846632653101
simpedak_db accreditation_instrument 44377 122241976213
simpedak_db user_group_access 5942 1850874716
simpedak_db modules 4678 2950270226
simpedak_db sidokaf_accreditation_transaction_chapter 916 637570318
simpedak_db hsi_module_sublist 623 474715036
pengiriman tujuan 503 475833724
simpedak_db quality_indicator 480 2356617626
simpedak_db quality_indicator_variable 429 812106784
simpedak_db location_village 404 20295082413
simpedak_db user_profile 393 1388428392
arsip_surat tbl_fa 256 343984636
arsip_surat tbl_suma 255 554686594
arsip_surat tbl_user 244 680327072
simpedak_db kalmut_katalogmutu 203 565400308
simpedak_db location_district 203 11836434480
simpedak_db filemanager 200 483215764
arsip_surat tbl_bidang 199 404032816
simpedak_db hsi_module_sublist_detail 177 228328340
simpedak_db local_quality_indicator_variable 177 334137580
simpedak_db accreditation_transaction_chapter 153 403920080
simpedak_db local_quality_indicator 153 460469650
simpedak_db kalmut_katalogmutu_deskripsi 152 785368840