Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Indexing tables with no data

Author  Topic 

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2003-10-09 : 14:12:40
Hi,
Do we ever need to index/defrag tables which contain no data?
Thanks,
Sarat.

**To be intoxicated is to feel sophisticated, but not be able to say it.**

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-09 : 14:20:47
Nope.

Tara
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2003-10-10 : 11:01:07
That's got to be the coolest post ever...

"If I don't have a car, do I still need a mechanic?"



Brett

8-)
Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-10-10 : 11:39:28
If you have a public library building with no books (or media of any type) can you even call it a library?

Jay White
{0}
Go to Top of Page

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2003-10-10 : 12:02:45
or -- does that "library" need a card catalog w/o any books?

- Jeff
Go to Top of Page

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2003-10-10 : 12:14:12
or a librarian to re-shelve books?

Jay White
{0}
Go to Top of Page

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-10-10 : 12:20:08
It's a very Zen question.


Damian
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-10 : 12:48:29
Sarat,

Will the table ever have data in it? If not, then why does it exist?

Tara
Go to Top of Page
   

- Advertisement -