Show us what you do! [message #671155] |
Thu, 16 August 2018 09:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
gazzag
Messages: 1119 Registered: November 2010 Location: Bedwas, UK
|
Senior Member |
|
|
I was perusing Richard Foote's Index Internals PDF from a link supplied by Ed Stevens here.
Can you spot the deliberate mistake? ![Wink](/forum/images/smiley_icons/icon_wink.gif)
SQL> CREATE TABLE test_delete (id NUMBER, name VARCHAR2(10));
Table created.
SQL> CREATE INDEX test_delete_idx ON test_delete (name);
Index created.
SQL> INSERT INTO test_delete VALUES (1, 'BOWIE');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> DELETE test_delete WHERE id = 1;
1 row updated.
SQL> SELECT file_id,block_id FROM dba_extents WHERE segment_name='TEST_DELETE_IDX';
FILE_ID BLOCK_ID
---------- --------------- 5 3441
SQL> ALTER SYSTEM DUMP DATAFILE 5 BLOCK 3442;
System altered.
|
|
|
|
|
|
|
|
Re: Show us what you do! [message #671217 is a reply to message #671155] |
Fri, 17 August 2018 04:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8964 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
I saw Mr Foote give a lecture at the ODTUG KScope convention in June. He is a edifying and entertaining speaker but he doesn't use live demonstrations, he relies on slides.
My style is the opposite: I do everything live. Of course, my demo's sometimes go spectacularly wrong. Particularly when lecturing on SQL tuning, which means playing games with the optimizer. Dangerous: the optimizer is cleverer than me. But it does mean that I can adjust the lecture content dynamically in response to questions, and people seem to find it entertaining.
|
|
|