Inconsistent Query Results
From: Adam Ruth <owski_at_hotmail.com>
Date: 24 Jun 2003 10:10:21 -0700
Message-ID: <f0f51c80.0306240910.214a1534_at_posting.google.com>
Date: 24 Jun 2003 10:10:21 -0700
Message-ID: <f0f51c80.0306240910.214a1534_at_posting.google.com>
Any feedback on this would be greatly appreciated,
analyze table tcomputer compute statistics
TCNO_ENTRY_ID COMPUTER_SYS_ID STATUS ------------- ---------------------------------------- ------ 1 2159101373 X 61 2159101373 X 101 2159101373 X 121 2159101373 X 201 2159101373 X 1 2159101490 X 61 2159101490 X 101 2159101490 X 121 2159101490 X 201 2159101490 X 1 2164192390 X 61 2164192390 X 101 2164192390 X 121 2164192390 X 201 2164192390 X 1 2199466309 X 61 2199466309 X 101 2199466309 X 121 2199466309 X 201 2199466309 X 1 2198383241 X 61 2198383241 X 62 2198383241 P 81 2198383241 P 101 2198383241 X 121 2198383241 X 162 2198383241 P 201 2198383241 X 230 2198383241 X 230 2199466309 X 230 2159101490 X 230 2159101373 X 230 2164192390 X33 rows selected
create index tcomputer_os_name on tcomputer(os_name)
Index created
analyze table tcomputer compute statistics
Table analyzed
TCNO_ENTRY_ID COMPUTER_SYS_ID STATUS ------------- ---------------------------------------- ------0 rows selected Received on Tue Jun 24 2003 - 19:10:21 CEST