Q & A

Q & A

Post by St. Lege » Tue, 29 Jun 1999 04:00:00

I am looking for information on program called Q&A.   It is an old
program(DOS) and I really need some

Barbare St. Le'ger


1. 2 Qs: Column statistics & selectivity

1.  How are column statistics used?
I've read Inside SQL Server 7.0 several times now and I see the
sentences that talk about column statistics, but I can't figure out how
the optimizer could possibly ever use such statistics.  Are they used
only by Query Analyzer and Index Wizard to provide the "advice" that
indexes 'should' be created on certain columns?

2. Is the % index selectivity value a lot lower in 7.0 than it used to
be (didn't it used to be that if an index would return 20% or more of a
table, the optimizer would choose a table scan or another index).  Now
it seems that the selectivity is between 1 and 5%.

2. I can not INSERT into Access95 using ADO.net and VB.NET

3. 3 Qs about tracing & tkprof

4. REF CURSORs and/or PL/SQL records

5. applying snapshot manually 2 Qs

6. sql 6.0 x 6.5

7. SQL 7.0 OLE DB Qs. Help!

8. Passing Parameters to a Stored QueryDef ?

9. Enabling TCP/IP server protocol BUG in SQL2K and SQL Server 6.5 native driver Qs

10. VB4EE/NT4/SS6.5 Security Qs

11. Multi Server Administration Qs

12. newbie qs; examining databases and tables